mysqlReplace string with regex
UPDATE table SET column = REGEXP_REPLACE(column, '[0-9]+', 'N');ctrl + ctableexample table name | columnname of column to update/replace |
REGEXP_REPLACE(columnexecutes regular expression replace replace over | '[0-9]+'regex pattern to search for |
'N'text to replace matched strings to | |
Related
More of Mysql
- How to find my.cnf config file
- Get largest tables list
- Insert new values only if row doesn't exist already
- Truncate all tables in a specific database
- What is the MEDIUMTEXT column max size (length) in Mysql
- Create dump of a database to a filename with date
- How to find duplicate varchar/text column values in table
- Make a pager (limit / offset) select query
- Disable ONLY_FULL_GROUP_BY mode
- Insert/update multiple rows in single query
See more codes...