mysql全局模糊查询
程序员文章站
2024-03-01 16:39:22
...
mysql语法:
SELECT * FROM tbl1
WHERE 字段1 LIKE *CONCAT*('%',#{keyWord},'%')
OR 字段2 LIKE CONCAT('%',#{keyWord},'%')
OR 字段3 LIKE CONCAT('%',#{keyWord},'%')
...