Mysql update data with regex -

is there anyway update rows of 1 text column , remove spaces in between string,

the data json string, following example string

{"id"                                      :"95703",  "lastname"         :"trigger",  "firstname"                               :"test", ... }

if notice there annoying white spaces between "id" , value :"95703",

is there anyway can (in update query) update rows , remove white space (using regex)

the sample query can run on table is

update `user_log_data` set data = {regex part}

"[ ]+:

try this.replace ":.see demo.

Hide