SELECT * FROM `test` WHERE name LIKE "%12%"
可以的
SELECT * FROM 表
WHERE SUBSTRING(NAME,'12',1)=null or SUBSTRING(NAME,'12',1)=','
那你直接where name = '12' 不就得了?
select * from (select * from news where name not like '%212%' ) where name like '%12%'
需求无法理解……查询的目标不清