求助MYSQL批量替换或删除两个字符之间内容的语句

发布网友发布时间：2022-04-07 17:52

共1个回答

热心网友时间：2022-04-07 19:21

mysql> set @str := "xxxxxxxxxxxxxxxx 123 这里内容不定456 xxxxxxxxxxxxxxxxxxxxx";
Query OK, 0 rows affected (0.00 sec)

mysql> select @str;
+--------------------------------------------------------------------------+
| @str |
+--------------------------------------------------------------------------+
| xxxxxxxxxxxxxxxx 123 这里内容不定456 xxxxxxxxxxxxxxxxxxxxx |
+--------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select replace(@str, substring_index(substring_index(@str, "123",-1), "456", 1), "替换的内容，或者变为空字符串就是删除");
+----------------------------------------------------------------------------------------------------------------------------------+
| replace(@str, substring_index(substring_index(@str, "123", -1), "456", 1), "替换的内容，或者变为空字符串就是删除") |
+----------------------------------------------------------------------------------------------------------------------------------+
| xxxxxxxxxxxxxxxx 123替换的内容，或者变为空字符串就是删除456 xxxxxxxxxxxxxxxxxxxxx |
+----------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

把上面的 @str 换成你的数据库的列名用在SQL语句里就可以实现效果了。