How to find and replace text in the MySQL database using SQL

MySQL database is a simple and useful string function REPLACE () which allows data to the table with the strings (from_string) to be replaced by new string (to_string). This is useful if you need to find and replace a text string that affects many rows or records, such as change of name, zip code, URL, [...]

Tags: database, Find, How, mySQL, replace, SQL, text

31.Dec.08 mySQL Comments (0)