Can MySQL do regular expression overrides in UPDATE?

Question

I have seen examples of MySQL SELECTusing a statement REGEXPto map.

Is there a way to do regular expression substitution in UPDATE?

If not, what is the easiest method to trigger regular expression substitution for all values ​​in a column?

Feel free to suggest using any programming language or regular expression.

Answer 1

In principle, no. You can use some bulky calls REPLACE(), create statements UPDATEin a script that supports regular expression replacement, or use some UDF, this is one of them