SELECT id,chinese_name,username,`status`,`password`,email,tel,create_at,update_at FROM op_users WHERE (username like ? or chinese_name like ?) and status = ? order by id desc
必要时加括号
mysql查询时,and or同时存在时,and的优先级高于or
最新推荐文章于 2024-07-05 02:14:16 发布