select * from t1 as a join t2 as b on a.id = b.id where CONCAT(a.name,b.name) like '%测试%' 转载于:https://www.cnblogs.com/refuge/p/10340817.html