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?

---

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

Or so I think.

---

select ID, date, timestamp
from yourtable
where DATE(`timestamp`) = CURDATE()