select something from awhere id_1=174 and id_2=2 and date Between now() - interval 70 Hour and now() - interval 50 hour; 上面语句是取距当前时间之前 70小时到50小时之间的记录。
select * from awhere id_1=174 and id_2=2 and `date` Between now() - interval 70 Hour and now() - interval 50 hour; orselect * from awhere id_1=174 and id_2=2 and `date` Between DATE_ADD(now(),INTERVAL -70 Hour) and DATE_ADD(now(),INTERVAL -50 Hour)
select something from a where id_1=174 and id_2=2 and date between now() - interval 50 hour and now();
select something from awhere id_1=174 and id_2=2 and `date` Between now() - interval 70 Hour and now() - interval 50 hour;1楼正解。字段名称尽量不要和关键字重名。
and date Between now() - interval 70 Hour and now() - interval 50 hour;
上面语句是取距当前时间之前 70小时到50小时之间的记录。
and `date` Between now() - interval 70 Hour and now() - interval 50 hour;
orselect * from awhere id_1=174 and id_2=2
and `date` Between
DATE_ADD(now(),INTERVAL -70 Hour) and
DATE_ADD(now(),INTERVAL -50 Hour)
and `date` Between now() - interval 70 Hour and now() - interval 50 hour;1楼正解。字段名称尽量不要和关键字重名。