Mysql

Mysql

how to limit the number of records mysql produces

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

how to count how many records of a field are in a database


 
how to use now() in a where clause mysql

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.