[SOLVED] Select from a certain month

[bschultz]

I'm trying to select only records from the month of March.

 

I've tried...

 

$sql = "SELECT date, title, text FROM table ORDER by date DESC WHERE `date` = DATE_SUB(CURDATE(),INTERVAL -2 month)";

 

and this...

 

$sql = "SELECT date, title, text FROM brian ORDER by date DESC WHERE `date` BETWEEN DATE_SUB(CURDATE( ) ,INTERVAL -2 MONTH) AND CURDATE( )";

 

 

Neither are working.  Can anyone help, please?

[bschultz]

this code works

 

$sql = "SELECT date_col, title, text FROM brian WHERE date_col BETWEEN '2008-04-01' AND '2008-05-01' order by date_col desc";