多字段匹配关键词查询
--旧写法:
where email like '%abc%' or address like '%abc%'
--组合查询写法:
where concat(email,address) like '%abc%'
多字段匹配关键词查询
--旧写法:
where email like '%abc%' or address like '%abc%'
--组合查询写法:
where concat(email,address) like '%abc%'