isnt logical AND not working with mySql?

fazbob

Im running mysql 3.23.58 on redHat 7.2 and i have noticed that when i do a logical AND selection from a table the results are not correct.

I have a table that has a field called date and some more fields. The date is a datetime variable.
My query is to select records from the table whose dates are in some range, like this:

select * from table where date >= '2005-07-20' and date <= '2005-07-25';

The results produced are ok except that they do not include the final date (2005-07-25).
I have tried different other alternation, like:

select from table where date >= '2005-07-20' & date <= '2005-07-25';
and even
select from table where date >= '2005-07-20' && date <= '2005-07-25';

But the results are wrong.

Is this a bug or am i using the wrong syntax?

Faz.

Lars_Berg

select * 
from t
 where date >= '2005-07-20' 
    and date <= '2005-07-25 23:59:59'

thorpe

you need to wrap the word date in backticks as im fairly certain its a reserved word in mysql.

select * from table where date >= '2005-07-20' && date <= '2005-07-25';

Lars_Berg

http://dev.mysql.com/doc/mysql/en/reserved-words.html

fazbob

Ya i had to use '2005-07-25 23:59:59' (till end of day), as Lars Berg says. Thorpe, thanks, but date seems to work fine, no need to wrap it in quotes..

thanks guys!

ps: where is the "mark resolved" link? why is it hidden so much?

leatherback

The mark thread resolved link is in the thread tools. And yes. It is hidden somewhat. Maybe the siteadmin can edit it, and place a link again at the bottom of the page, where it used to be?