in date_sub function while using a interval can we use an interval of month and day combined?
===

If I need to select database for the past month is this the correct way?


    $month1=mysql_query("select * from users where date_sub(concat(curdate(), ' 00:00:00'), interval 1 month day(curdate()) day) < start and start < date_sub(concat(curdate(), ' 00:00:00'), interval day(curdate()) day)");

Is this field correct in particular: `date_sub(concat(curdate(), ' 00:00:00'), interval 1 month day(curdate()) day)`

Is there any best short alternative to simply select a table of previous month from the DB?
