How to select the matching details from table mysql query equal to current date

[eluser]n0xie[/eluser]
Do you mean like this?

Code:

SELECT * FROM `my_table` WHERE date BETWEEN ('2010-10-27 10:30:00') AND ('2010-10-27 18:30:00');