so right now I'm storing a the date of each search done on my site like this
2011-06-07 21:44:01
now I'd like to execute a query to select all values where the date is equal to whatever, but only the year / month and day are taken into account, so it would be like
mysql_query("SELECT tag from tags WHERE date = '2011-06-07'");
but it shouldn't take into account the exact time (hour minute seconds), is there any way to do this?
You could use the DATE()
function.
SELECT `tag`
FROM `tags`
WHERE DATE(`date`) = '2011-06-07'
However, for better performance you could use...
WHERE `date`
BETWEEN '2011-06-07'
AND '2011-06-07 23:59:59'