SELECT * FROM 表名WHERE CONCAT(IFNULL(`字段名`,''),IFNULL(`字段名`,''),IFNULL(`字段名`,'')) LIKE '%参数%'
MYSQL多字段模糊查询
最新推荐文章于 2024-03-11 16:21:04 发布
SELECT * FROM 表名WHERE CONCAT(IFNULL(`字段名`,''),IFNULL(`字段名`,''),IFNULL(`字段名`,'')) LIKE '%参数%'