Q:

mysql between query

I have this scheme:
--------------------------
| ID | data  | timestamp |
--------------------------

how i can make a query to show only today values?
I now i need to use the BETWEEN statement, any idea?

A:

SELECT   *
FROM     mytable
WHERE    DATE(timestamp) = CURDATE()

Or so I think.

