Pintér Tibor (tibyke) wrote:
Select * from <TABLE> where date > _2005-01-07_ and date < DATE_ADD(_2005-01-07_, INTERVAL 24 HOUR)
However is there a simpler way of doing it by just passing one date like
Select * from <TABLE> where date = _2005-01-07_
you may also go for "... WHERE year(foo)=a AND month(foo)=b AND dayofmonth(foo)=c;"
t
That will work, but it will not use the index on foo, forcing a full table scan.
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
