极客教程MySQL 如何使用REPLACE()函数在MySQL中查找和替换数据以更新表格？
我们知道REPLACE()函数用于在字符串中用另一个字符串替换子字符串的出现次数。我们也可以在UPDATE语句中使用REPLACE函数来查找和替换数据以更新表格。
阅读更多：MySQL 教程
示例
mysql> Update Student set Father_Name = REPLACE(Father_Name, 'Mr.','Shri ');
Query OK, 5 rows affected (0.06 sec)
Rows matched: 5 Changed: 5 Warnings: 0
mysql> Select Name, Father_Name from Student;
+---------+-----------------+
| Name | Father_Name |
+---------+-----------------+
| Gaurav | Shri Ramesh |
| Aarav | Shri Sanjay |
| Harshit | Shri Lovkesh |
| Gaurav | Shri Ramchander |
| Yashraj | Shri Mohan |
+---------+-----------------+
5 rows in set (0.00 sec)
上述查询通过查找“Mr.”并用“Shri”替换同样的字符串，更新了Father_name列。