LIKE

select * from Persons where city not like "%lon%"

推荐阅读更多精彩内容