如
a
id content
1 aaaad,顶顶顶,6m时尚。顶顶顶sss
2 顶顶顶啊啥,6m时尚。地方地方,地方事实上
有没sql能清除 6m时尚后面数据
得到如下结果
id content
1 aaaad,顶顶顶,
2 顶顶顶啊啥,
a
id content
1 aaaad,顶顶顶,6m时尚。顶顶顶sss
2 顶顶顶啊啥,6m时尚。地方地方,地方事实上
有没sql能清除 6m时尚后面数据
得到如下结果
id content
1 aaaad,顶顶顶,
2 顶顶顶啊啥,
调试欢乐多
mysql> update a set content = if(instr(content, '6m时尚')=0, content, substring(content, 1, instr(content, '6m时尚')-1));
Query OK, 2 rows affected (0.02 sec)
Rows matched: 3 Changed: 2 Warnings: 0
Query OK, 0 rows affected (0.00 sec)mysql> SELECT SUBSTRING_INDEX(@x, '6m', 1);
+------------------------------+
| SUBSTRING_INDEX(@x, '6m', 1) |
+------------------------------+
| aaaad,顶顶顶, |
+------------------------------+
1 row in set (0.00 sec)mysql>