Mysql query madness

[bitbit.tk]

Hi all!

I have a tabla with a field in it named date. I am trying to get results for today…
when I try
SELECT *
FROM table1
WHERE date = ‘2010-02-12’ //as for today
it works fine

But the problem when i try
SELECT *
FROM table1
WHERE date = ‘CURDATE()’

it returns 0 results, but the one above gives about 20!

Any help please?

[chrisb]

WHERE date = ‘CURDATE()’

Are you really sure you want to compare the date field to a text string with the content ‘CURDATE()’ …?

[bitbit.tk]

this was really stupid!

thank you so much!

SELECT *
FROM table
WHERE date = CURDATE() worked fine!