UPDATE love_tc_tag_copy1 SET deleted_at = '2023-09-14 10:05:42'
where LENGTH(tag_name) < 3
or tag_name like '% %'
or tag_name like '%丶%'
or tag_name like '%，%'
or tag_name like '%：%'
or tag_name like '%《%'
or tag_name like '%“%'
or tag_name like '%、%'
or tag_name like '%�%'
or tag_name like '%……%'
or tag_name like '%—%'
or tag_name like '%”%'
or tag_name like '%。%'
or tag_name like '%！%'
or tag_name like '%（%'
or tag_name REGEXP '[:\.\*\~\,\!\@\#\$\%\^\&\(\)\_\-]'
or tag_name REGEXP '[^0-9.]' = 0
or tag_name REGEXP '^[A-z]+$'将数据库中带有特殊符号的数据伪删除
发表于
发表回复