多表联合查询,利用 concat 模糊搜索

select * from t1 as a 

join t2 as b

on a.id = b.id

where CONCAT(a.name,b.name) like '%测试%'

posted @ 2019-01-31 10:26  热敷哥  阅读(281)  评论(0)  编辑  收藏  举报