在mysql中查询问题 [英] Query problem in mysql
问题描述
这是我在数据库中过滤数据的mysql查询:
This is my mysql query to filter data in DB:
$MyQuery = 'SELECT * FROM `class` WHERE `Date` >= CURDATE() AND CURTIME() < End_Time';
我应该根据该查询获得数据。
但如果我输入
I should get data base on that query.
But if I input my
End Time
少于
CURTIME()
和
Date
等于或更大然后
CURDATE()
我得到空数据!
我尝试了什么:
在数据库中执行此查询数据时,更改数据库中的数据类型仍然出错
$ MyQuery ='SELECT * FROM`class` WHERE`Date`> = CURDATE()AND CURTIME()< End_Time';
i got empty data!
What I have tried:
Change datatype in database still got error when execute data in database base on this query
$MyQuery = 'SELECT * FROM `class` WHERE `Date` >= CURDATE() AND CURTIME() < End_Time';
推荐答案
MyQuery = ' SELECT * FROM`class` WHERE`Date`> = CURDATE()AND CURTIME()< End_Time';
MyQuery = 'SELECT * FROM `class` WHERE `Date` >= CURDATE() AND CURTIME() < End_Time';
我应该根据该查询获得数据。
但如果我输入
I should get data base on that query.
But if I input my
End Time
少于
CURTIME()
和
Date
等于或更大然后
CURDATE()
我得到空数据!
我尝试了什么:
在数据库中执行此查询数据时,更改数据库中的数据类型仍然出错
i got empty data!
What I have tried:
Change datatype in database still got error when execute data in database base on this query
MyQuery ='SELECT * FROM`class` WHERE`Date`> = CURDATE()AND CURTIME()< End_Time';
MyQuery = 'SELECT * FROM `class` WHERE `Date` >= CURDATE() AND CURTIME() < End_Time';
你的子句看起来有点混乱:
所以你的条款说:
`Date`大于(或等于)now
End_Time比现在大
也许这是正确的?我不知道你的查询需要做什么,但看起来你想要在Date和End_Time之间的日期范围?
在这种情况下你可以使用之间:
You where clause looks a little muddled:
So your clause says that:
`Date` is greater than (or equal to) now
End_Time is greater than now
Maybe that's correct? I don't know what you need your query to do, but it looks like your going for a date range between Date and End_Time?
in which case you can use between:
WHERE CURDATE() between `Date` AND End_Time
介于两端的包容性因此可能不完美
如果那不是问题那么请澄清日期的背景和一般的查询
Between is inclusive at both ends so may not be perfect
If that's not the issue then please clarify the context of the dates and the query in general
这篇关于在mysql中查询问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!