REPLACE function
REPLACE function
The mysql REPLACE function allows all sort of string manipulation, even inside statements :
REPLACE(str,from_str,to_str)
Returns the string str with all occurrences of the string from_str replaced by the string to_str.
examples :
replace string in all records from a table :
update table1 set field1 = replace (field1, “one”, “two”);
