MySQL search and replace some text in a field

Question

What MySQL query will do a text search and replace in one particular field in a table   I e  search for foo and replace with bar so a record with a field with the value hello foo becomes hello bar

User · Answer

In my experience  the fastest method is  UPDATE table name SET field   REPLACE field   foo    bar   WHERE field LIKE   foo      The INSTR   way is the second-fastest and omitting the WHERE clause altogether is slowest  even if the column is not indexed

User · Answer

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    gt  0     REPLACE  string functions  INSTR  string functions

User · Answer

And if you want to search and replace based on the value of another field you could do a CONCAT   update table name set  field name    replace  field name   YOUR OLD STRING  CONCAT  NEW STRING   OTHER FIELD VALUE   AFTER IF NEEDED       Just to have this one here so that others will find it at once

User · Answer

UPDATE table SET field   replace field  text needs to be replaced  text required     Like for example  if I want to replace all occurrences of John by Mark I will use below    UPDATE student SET student name   replace student name   John    Mark

User · Answer

The Replace string function will do that

User · Answer

UPDATE table name  SET field   replace field   string-to-find    string-that-will-replace-it

User · Answer

I used the above command line as follow  update TABLE-NAME set FIELD   replace FIELD   And    and    the purpose was to replace And with and   A  should be lowercase   The problem is it cannot find the  And  in database  but if I use like   And   then it can find it along with many other ands that are part of a word or even the ones that are already lowercase

[mysql] MySQL search and replace some text in a field

Examples related to mysql

Examples related to sql

Examples related to search

Examples related to replace