多表多字段模糊查询
2019-10-08 本文已影响0人
define光年
SELECT * FROM gdh_flower_order a INNER JOIN gdh_flower_worker b ON a.wid=b.id WHERE a.uniacid = '6' AND ( CONCAT(IFNULL(order_id,''),IFNULL(u_lianxiren,''),IFNULL(u_tel,''),IFNULL(u_company,''),IFNULL(realname,'')) LIKE '%老杨%' ) ORDER BY a.createtime DESC LIMIT 0,10
多表多字段模糊查询
