mysql - sql查询错误数据没有正确获取数据

Question

以下 SQL 查询不返回任何结果:

SELECT * 
FROM regtb 
WHERE name LIKE 'Karnataka' OR 
      email LIKE 'Karnataka' OR 
      mobile LIKE 'Karnataka' OR 
      city LIKE 'Karnataka' OR 
      ocity LIKE 'Karnataka' AND 
      date BETWEEN '2015-04-07' AND '2015-04-11' 
ORDER BY id

查询到的表结构如下:

编号
电子邮件
密码
姓名
城市
手机
实验
技能
丑
页面
博士
日期

欢迎任何帮助

Answer 1

试试这个:

SELECT * FROM regtb 
WHERE (name LIKE 'Karnataka%' OR email LIKE 'Karnataka%' 
OR mobile LIKE 'Karnataka%' OR city LIKE 'Karnataka%' 
OR ocity LIKE 'Karnataka%') 
and (date between '2015-04-07' and '2015-04-11') 
ORDER BY id