How to display todays records from mysql table having name as varchar and date as datetime?

Answers

1. Dragosh

   On 2006-08-11 12:24:12

   
   
   SELECT * FROM yourtablename WHERE datetime = todays dat in the format you specified in the table when creating it

2. John J

   On 2006-08-11 13:27:29

   
   
   SELECT * FROM table WHERE substring( date,1,10 ) = CURDATE(); should work.

3. ronald t

   On 2006-08-11 12:23:36

   
   
   SELECT * FROM table WHERE date>2006-08-11