there is a very simple method to limit the number of records mysql produces
how to count how many records of a field are in a database
I wanted to return from the database all items that were time stamped today using the now() function. But needed to trim both the time stamp and the now.