Search and replace JSON in Mysql with regex

Question

Is it possible to search and replace with a regex expression in MySQL?

I have a thousand values on a column containing a JSON string, somewhere inside each JSON are several occurrences of a string that I have to change.

I've already made a PHP script that do the job, but it is a little slow.

Is there a nicer way to do that using only MySQL?

Something like:

UPDATE mytable SET value = "disabled" WHERE data REGEXP '{"field": "(.+)"}'

Rick James · Accepted Answer · 2015-08-16 18:54:40Z

1

MariaDB has REGEXP_REPLACE(), which might provide the tool you need.

answered Aug 16, 2015 at 18:54

Rick James

144k15 gold badges144 silver badges255 bronze badges

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

1 Answer 1