how to use now() in a where clause mysql

how to use now() in a where clause mysql

I had a table which had a timestamp on it, and i only wanted to return records that were timestamped today, however it was date and time stamped so needed to find a way to shorten the now() and my timestamp column

This is what i came up with:

select timestamp from table where left(timestamp,10)=left(now(),10);

Worked a treat

 


SELL SELL SELL