MySQL for replace with wildcard

by

Update: MySQL 8.0 has a function REGEX_REPLACE().

Below is my answer from 2014, which still applies to any version of MySQL before 8.0:

REPLACE() does not have any support for wildcards, patterns, regular expressions, etc. REPLACE() only replaces one constant string for another constant string.

You could try something complex, to pick out the leading part of the string and the trailing part of the string:

UPDATE table
SET Configuration = CONCAT(
      SUBSTR(Configuration, 1, LOCATE('<tag>', Configuration)+4),
      NEW_DATA,
      SUBSTR(Configuration, LOCATE('</tag>', Configuration)
    )

But this doesn’t work for cases when you have multiple occurrences of <tag>.

You may have to fetch the row back into an application, perform string replacement using your favorite language, and post the row back. In other words, a three-step process for each row.

More Related Contents:

  1. MySQL search and replace some text in a field
  2. Can MySQL replace multiple characters?
  3. Replace Into Query Syntax
  4. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  5. SQL Query needed for fetch value from Two identical table but not fully identical table
  6. SQL select only rows with max value on a column [duplicate]
  7. How to create a MySQL hierarchical recursive query?
  8. How to reset AUTO_INCREMENT in MySQL
  9. SELECTING with multiple WHERE conditions on same column
  10. MySQL Query GROUP BY day / month / year
  11. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  12. How to find gaps in sequential numbering in mysql?
  13. MySQL: Invalid use of group function
  14. Combining UNION and LIMIT operations in MySQL query
  15. MySQL comparison with null value
  16. MySQL Like multiple values
  17. Matching all values in IN clause
  18. INTERSECT in MySQL
  19. Check for x consecutive days – given timestamps in database
  20. How do I get the ID of multiple inserted rows in MySQL?
  21. How to alter a column and change the default value?
  22. MySql Transpose Row into Column and Column into Row [duplicate]
  23. How to select column names dynamically in mySQL
  24. sql join tables where 1 column has comma
  25. Remove special characters from a database field
  26. update a column by subtracting a value
  27. get a recursive parent list
  28. Execute INSERT if table is empty?
  29. MySQL: Computed Column
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment