WHERE column_name = some_value 貌似不行！该怎么改？

Question

表XWW中包括如下栏term_id name slug term_group term_order栏slug中有若干行中有如下数据：%E2%80%9EThe+dream+of+the+sailor%E2%80%9D++%E2%80%9EThe+dream+of+the+sailor%E2%80%9D%9EThe+dream+of+the+sailor%E2%80%9D+其中“+”号有在行首、行中、行末的，希望删除行首、行末带“+”号的栏sql命令该怎么写，谢谢DELETE FROM table_nameWHERE column_name = some_value 貌似不行

Answer 1

可以substring 也可以用 正则
substring 判断行首或行末的第一字符，这里就不写了
我写一下正则的，个人觉得正则最方便

删除首行带+号的
DELETE FROM table_name WHERE slug REGEXP '^#.*'

删除行末带+号的
DELETE FROM table_name WHERE slug REGEXP '^#.*'

删除首行带+号且行末也带+号的
DELETE FROM table_name WHERE slug REGEXP '^#.*#$'

正则的东西自己玩