mysql - how to replace a sub-string?

Question

a field is a varchar, i want to replace a sub string of this field.

ab123fg => ab456fg

the above is just a example. just like the sub string to be replaced.

how do you identify which part of your string needs replacing? Is it the 1st set of numbers? or characters 3,4,5 or something else? — dnagirl
– dnagirl, Commented May 10, 2012 at 19:20

472084 · Accepted Answer · 2012-05-11 08:30:59Z

4

REPLACE(str, 'ab123fg ', 'ab456fg')

EDIT:

MySQL doesnt have a find and replace regex function, maybe have a look at UDFs

answered May 10, 2012 at 19:20

472084

17.9k10 gold badges67 silver badges82 bronze badges

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

1 Answer 1