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_name
WHERE 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 '^#.*#$'正则的东西自己玩