jtlgb

导航

统计
 

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

posted on 2019-08-29 15:17 jtlgb 阅读(...) 评论(...) 编辑 收藏