December 31st, 2008 -
![]()
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, or spelling.
The syntax of REPLACE is REPLACE(text_string, from_string, to_string)
Reference described in REPLACE function that returns the string text_string with all occurrences of the string from_string replaced by the chain to_string, where correspondence is sensitive when ...
Read more
Tags: database, Find, How, mySQL, replace, SQL, text
Posted in mySQL | No Comments »