MySQL string replace

by 
UPDATE your_table
SET your_field = REPLACE(your_field, 'articles/updates/', 'articles/news/')
WHERE your_field LIKE '%articles/updates/%'

Now rows that were like

http://www.example.com/articles/updates/43

will be

http://www.example.com/articles/news/43

http://www.electrictoolbox.com/mysql-find-replace-text/

More Related Contents:

  1. How can I use mySQL replace() to replace strings in multiple records?
  2. MySQL search and replace some text in a field
  3. How to count words in MySQL / regular expression replacer?
  4. Can MySQL replace multiple characters?
  5. Replace Into Query Syntax
  6. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  7. MySQL for replace with wildcard
  8. MySql Query Replace NULL with Empty String in Select
  9. How to search and replace all instances of a string within a database?
  10. how to delete data from table A besides the customer service and director data in table B?
  11. Get records with max value for each group of grouped SQL results
  12. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  13. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  14. Using an Alias in SQL Calculations
  15. How to get difference between two dates in months using MySQL query?
  16. MySQL – Control which row is returned by a group by
  17. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  18. Using ORDER BY and GROUP BY together
  19. How can VBA connect to MySQL database in Excel?
  20. MySQL Pivot Table Column Data as Rows
  21. updating columns with a sequence number mysql
  22. How repair corrupt xampp ‘mysql.user’ table?
  23. Select a column with a keyword name
  24. Select all months within given date span, including the ones with 0 values
  25. ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  26. Use Composite Primary Key as Foreign Key
  27. Xampp-mysql – “Table doesn’t exist in engine” #1932
  28. Unserialize through query at database level itself
  29. MySQL throws Incorrect string value error
  30. ORDER BY alphabet first then follow by number

Leave a Comment