How to do a regular expression replace in MySQL?

MySQL 8.0+:

You can use the native REGEXP_REPLACE function.

Older versions:

You can use a user-defined function (UDF) like mysql-udf-regexp.

Related Contents:

  1. MySQL Split Comma Separated String Into Temp Table
  2. MySQL strip non-numeric characters to compare
  3. How to remove all non-alpha numeric characters from a string in MySQL?
  4. How to extract two consecutive digits from a text field in MySQL?
  5. How to extract the nth word and count word occurrences in a MySQL string?
  6. How to count words in MySQL / regular expression replacer?
  7. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  8. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  9. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  10. Does MySQL Regexp support Unicode matching
  11. How to regex in a MySQL query
  12. How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
  13. How To have Dynamic SQL in MySQL Stored Procedure
  14. MySQL: Insert record if not exists in table [duplicate]
  15. MySQL error 2006: mysql server has gone away
  16. What is the ideal data type to use when storing latitude / longitude in a MySQL database?
  17. MySQL Server has gone away when importing large sql file
  18. MySQL offset infinite rows
  19. Is there a REAL performance difference between INT and VARCHAR primary keys?
  20. How do you select every n-th row from mysql
  21. Howto: Clean a mysql InnoDB storage engine?
  22. Get records with highest/smallest per group
  23. Ordering by specific field value first
  24. Storing JSON in database vs. having a new column for each key
  25. How to store arrays in MySQL?
  26. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  27. Can I create view with parameter in MySQL?
  28. How should I store GUID in MySQL tables?
  29. Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How do I grant privileges?
  30. Equivalent of Oracle’s RowID in MySQL
  31. Convert MySQL schema to Github Wiki?
  32. How to convert all tables from MyISAM into InnoDB?
  33. Get the latest date from grouped MySQL data
  34. How can I get rid of these comments in a MySQL dump?
  35. Add Auto-Increment ID to existing table?
  36. Capitalize first letter of each word, in existing table
  37. Error renaming a column in MySQL
  38. Access mysql remote database from command line
  39. Dropping Unique constraint from MySQL table
  40. MySQL giving “read ECONNRESET” error after idle time on node.js server
  41. How to insert values in table with foreign key using MySQL?
  42. Advanced MySql Query: Update table with info from another table
  43. Proper database model for a user feedback system (an interesting case)
  44. ColdFusion Parameterizing a Query
  45. dump all mysql tables into separate files automatically?
  46. Case Expression vs Case Statement
  47. MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found
  48. Find date range overlaps within the same table, for specific user MySQL
  49. MySQL: Many tables or many databases?
  50. How to integrate ElasticSearch with MySQL?

Leave a Comment