String regex on sql

Question

I have "X1lNtWp4_e" type of string on SQL code.

I wanna convert like X1lNtWp4_e without the ( " ).

My DB Engine codes like MySQL I think.

I'm using http://chartio.com so i'm not sure which db engine.

Matt · Accepted Answer · 2016-06-02 08:49:28Z

1

Chartio is just a front end but assuming your DB is MySQL simply use:

Use the TRIM function with the BOTH argument:

SELECT TRIM(BOTH '"' FROM '"X1lNtWp4_e"')
FROM yourtable

Use the REPLACE function if the middle content contains " also and you want them removed:

SELECT REPLACE('"X1lNtWp4_e"', '"', '')
FROM yourtable

answered Jun 2, 2016 at 8:49

Matt

15.1k28 gold badges109 silver badges161 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1