Searching MYSQL using date not datetime

[blmg2009]

Hi there, 

 

I'm a bit of a newbie and I have done a search online, but i'm still confused. 

 

I need to search my MYSQL database in a filed named date_mod I need to search for todays date only $date=gmdate("Y-m-d");

 

But however the field is a datetime option so how can I search only todays date and not both date and time. 

 

Thank you for reading. 

[Barand]

Use the DATE() function which returns just the date portion of a datetime field eg

WHERE DATE(mydatefield) = '2014-09-18'

[davidannis]

Use LIKE in your query.

 

WHERE date_mod LIKE '$date%';

Edited September 18, 2014 by davidannis

[blmg2009]

Brillaint thank you, I will try this I was thinking of WHERE datetime LIKE '2014-09-18%', but I thought they should be a much better practice than this. 

[Jacques1]

This LIKE hack is really not a good solution. Use the DATE() function as suggested by Barand.