删除整条记录delete from a where b like '%.abc'只是清空含有.ACB的B字段:update a set b = null where b like '%.abc'
delect from a where b like '%.abc%'
delete from a where b like '%.abc'
delete a where b like '%abc'
