多表联合查询,利用 concat 模糊搜索 select * from t1 as a join t2 as b on a.id = b.id where CONCAT(a.name,b.name) like '%测试%'