MySQL search and replace some text in a field

by

Change table_name and field to match your table name and field in question:

UPDATE table_name SET field = REPLACE(field, 'foo', 'bar') WHERE INSTR(field, 'foo') > 0;

More Related Contents:

  1. Can MySQL replace multiple characters?
  2. Search all columns of a table using a single where condition with single keyword in mysql
  3. Replace Into Query Syntax
  4. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  5. MySQL for replace with wildcard
  6. SQL select only rows with max value on a column [duplicate]
  7. SELECTING with multiple WHERE conditions on same column
  8. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  9. How to find gaps in sequential numbering in mysql?
  10. MySQL: Invalid use of group function
  11. Combining UNION and LIMIT operations in MySQL query
  12. MySQL find_in_set with multiple search string
  13. MySQL JOIN the most recent row only?
  14. OUTPUT Clause in MySQL
  15. What does SQL clause “GROUP BY 1” mean?
  16. Sorting by date & time in descending order?
  17. Case statement in MySQL
  18. MySQL: Inner join vs Where [duplicate]
  19. Syntax error when using except in a query
  20. Selecting from two tables with inner join and limit [duplicate]
  21. Why the order of evaluation for expressions involving user variables is undefined?
  22. sql like operator on integer
  23. How to select data where a field has a min value in MySQL?
  24. MySQL – SELECT * INTO OUTFILE LOCAL ?
  25. How to SELECT by MAX(date)?
  26. The best way to remove value from SET field?
  27. get a recursive parent list
  28. INSERT INTO Table from multiple tables
  29. Execute INSERT if table is empty?
  30. Mysql How do you create a clustered index?

Leave a Comment