How to use the REPLACE() function in MySQL

REPLACE()

REPLACE(str,from_str,to_str)The function is used to replace all from_str in the string str with to_str and return the replaced string. For example:

SELECT REPLACE('MySQL字符串函数', '字符串', '日期') AS str1, REPLACE('MySQL字符串函数', '字符串', '') AS str2; str1 |str2 | ------------+---------+ MySQL日期函数|MySQL函数|

In addition,INSERT(str,pos,len,newstr)The function is used to insert the substring newstr after the specified position pos of the string str, replacing the subsequent len characters . For example:

SELECT INSERT('MySQL字符串函数', 6, 3, '日期') AS str; str | ------------+ MySQL日期函数|

The above is the detailed content of How to use the REPLACE() function in MySQL. For more information, please follow other related articles on the PHP Chinese website!