Update a column value, replacing part of a string

by 
UPDATE urls
SET url = REPLACE(url, 'domain1.example/images/', 'domain2.example/otherfolder/')

More Related Contents:

  1. How can I return pivot table output in MySQL?
  2. Using LIMIT within GROUP BY to get N results per group?
  3. How to perform grouped ranking in MySQL
  4. Required to join 2 tables with their FKs in a 3rd table
  5. MySQL Trigger after update only if row has changed
  6. Does COUNT(*) always return a result?
  7. Ordering by specific field value first
  8. MySQL “Group By” and “Order By”
  9. How to change the CHARACTER SET (and COLLATION) throughout a database?
  10. MySQL Query to select data from last week?
  11. Connect By Prior Equivalent for MySQL
  12. How do I add a custom CHECK constraint on a MySQL table?
  13. The total number of locks exceeds the lock table size
  14. MySQL variable format for a “NOT IN” list of values
  15. Convert partially non-numeric text into number in MySQL query
  16. MySQL “IN” operator performance on (large?) number of values
  17. How to get the latest record in each group using GROUP BY? [duplicate]
  18. Order by COUNT per value
  19. MySQL Select last 7 days
  20. Second SELECT query if first SELECT returns 0 rows
  21. Difference between two table structure
  22. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  23. How to retrieve JSON data from MySQL?
  24. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  25. Why MySQL is giving error “Not allowed to return a result set from a function”?
  26. When to use a left outer join?
  27. INSERT INTO Table from multiple tables
  28. Execute INSERT if table is empty?
  29. Mysql How do you create a clustered index?
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment