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

HOW TO GET MORE CUSTOMERS

How to stop paying council tax 

I'm having a clear out, new things added daily

How to stop paying council tax

Stunning cushion 40cm x 40cm...

Stunning cushion 40cm x 40cm Constellations of thoughts


£24.00

Matt Handcock Pin cushion...

Matt Handcock Pin cushion


£3.99

Wine bottle gift bag/ holder...

Wine bottle gift bag/ holder linen new hand made


£3.00

Bean Bag door stop - new ...

Bean Bag door stop - new


£4.00

New Glasses Holder...

New Glasses Holder


£4.00

New Glasses Holder...

New Glasses Holder


£4.00

Stunning cushion 40cm x 40cm...

Stunning cushion 40cm x 40cm Constellations of thoughts


£24.00

Cleaner in Woking