select * from aaat where t.codename like '%天津%';
如果想多个模糊查询可以用or,如:
select * from aaa where t.codename like '%天津%' or t.codename like '%上海%' ;
select * from aaat where t.codename like '%天津%';
如果想多个模糊查询可以用or,如:
select * from aaa where t.codename like '%天津%' or t.codename like '%上海%' ;
转载于:https://www.cnblogs.com/xyyou/p/11004238.html