MySQL利用LOCATE,CONCAT查询

SELECT
*
FROM
table t
WHERE 1=1
AND LOCATE(#{searchParams},CONCAT(t.account,IFNULL(t.id,''),IFNULL(t.name,''),IFNULL(t.phone,''))) > 0