SELECT * FROM `表名` WHERE CONCAT(IFNULL(`字段1`,''),IFNULL(`字段2`,''),IFNULL(`字段3`,'')) LIKE ‘%关键字%’
MySQL实现多字段拼接模糊查询
最新推荐文章于 2023-04-25 10:39:30 发布
SELECT * FROM `表名` WHERE CONCAT(IFNULL(`字段1`,''),IFNULL(`字段2`,''),IFNULL(`字段3`,'')) LIKE ‘%关键字%’