摘要： SELECT * FROM table t WHERE 1=1 AND LOCATE(#{searchParams},CONCAT(t.account,IFNULL(t.id,''),IFNULL(t.name,''),IFNULL(t.phone,''))) > 0 阅读全文