Regex string replace in mysql

Question

Is there a simple way to do the following in mysql:

"Value ( some stuff here) " --> "Value"

Something similar to REPLACE("(*)","")? How would I go about doing this and stripping the remaining whitespace?

Kyle · Answer 1 · 2012-12-30T22:23:39.497

0

Try:

"/s*/(.*/)/s*"

This will match leading whitespace, the text in parenthesis and trailing whitespace.

Look at UDFs(user defined functions). You'll want something like oracle's REGEXP_REPLACE

edited Dec 30 '12 at 22:23

answered Dec 30 '12 at 21:41

Kyle

1,019
1
10
19

1

MySQL don't supports regexp – edem Dec 30 '12 at 21:43
2

Sorry, I wrote it about find & replace function in mysql – edem Dec 30 '12 at 21:54

score 0 · Accepted Answer · edited May 23 '17 at 12:18

0

In mysql you cannot replace items of rows with regexp help. So you have to select all values "Value ( some stuff here) " from a defined column. Process them on a client-side with python facilities. After that you need update all rows in a mysql database.

Or you can read this answers How to do a regular expression replace in MySQL?

edited May 23 '17 at 12:18

Community

1
1

answered Dec 30 '12 at 21:55

edem

3,222
3
19
45

Regex string replace in mysql

2 Answers2