mysql语法:
SELECT * FROM tbl1
WHERE 字段1 LIKE *CONCAT*('%',#{keyWord},'%')
OR 字段2 LIKE CONCAT('%',#{keyWord},'%')
OR 字段3 LIKE CONCAT('%',#{keyWord},'%')
...
mysql语法:
SELECT * FROM tbl1
WHERE 字段1 LIKE *CONCAT*('%',#{keyWord},'%')
OR 字段2 LIKE CONCAT('%',#{keyWord},'%')
OR 字段3 LIKE CONCAT('%',#{keyWord},'%')
...