1. 对于两个field，同一关键字模糊查询
select id,name,email from orders where concat(name,email) like '%aa%'
2. 对于两个以上field，用||
select id,name,email from orders where lower(name||email||address) like '%aa%'
3. 多字段多关键字查询
select id,name,email from orders where concat(name,email) like '%aa%bb%' |
|
转播
