- 多条件模糊查询
select * from t_log where (LOCATE('wu', user_name) > 0 or LOCATE('wu', params ) > 0)and (method='POST' or method='GET');
- 查询id在列表中的所有结果
select * from t_user where tenant_id in (1,2,3);
select * from t_log where (LOCATE('wu', user_name) > 0 or LOCATE('wu', params ) > 0)and (method='POST' or method='GET');
select * from t_user where tenant_id in (1,2,3);