mysql date operation problem??

[PHPycho]

I am trying to display all the news which are up to todays date. I have used following query but didnt get the success

$sql = "SELECT * FROM news WHERE news_date < = todays_date";

May be i have not enough knowledge about date operation in mysql. What i want is just your help .
Thanks a lot.

[guelphdad]

Did you look at Date and Time functions in the mysql manual to see how to do what you wanted?

[PHPycho]

is there anyway to find the the week from yyyy-mm-dd format using mysql ?

[guelphdad]

select week(yourdatecolumn)

[PHPycho]

Pardon again .i was not clear in my question
Suppose what should i do if i would like to find the week on month of 2007-03-12 and the answer should be 2nd ie 2...
thanks again