Page 1 of 1

Mysql query problem

Posted: Tue Jan 11, 2011 8:29 am
by mrlayance

Code: Select all

WHERE `time` BETWEEN 'Jan 1 %' AND 'Jan 8 %' AND ...
Results
Jan 1 00:33:23
Jan 10 08:52:05

How would I avoid the Jan 10 results?

I have tried a few different combinations with %, <=, etc.

Any ideas? :banghead:

Re: Mysql query problem

Posted: Wed Jan 12, 2011 7:49 am
by Darhazer
what is the datatype of the field? Hope it's not char/varchar?