9951 explained code solutions for 126 technologies


mysqlReplace string with regex


UPDATE table SET column = REGEXP_REPLACE(column, '[0-9]+', 'N');ctrl + c
table

example table name

column

name of column to update/replace

REGEXP_REPLACE(column

executes regular expression replace replace over column column

'[0-9]+'

regex pattern to search for

'N'

text to replace matched strings to