mysql 模糊查询语句

--语句：
select * from 表名 where 列名1 like '%关键字1%' and 列名2 like '%关键字2%' and 列名3 like '%关键字3%' and 列名4 like '%关键字4%' ;

--示例：
select * from bank_branch_number where bankName like '%工商%' and provinceName like '%江苏%' and cityName like '%苏州%' and bankFullName like '%盛泽支行%' ;

--查询结果：
-- [{"cityName":"苏州市","cityId":"100500","provinceName":"江苏省","provinceId":"100000","bankName":"中国工商银行","branchNo":"102305402210","bankFullName":"中国工商银行吴江盛泽支行","bankId":"1"}]