date_format() query problem

[macca_25]

Hi all,
I have the following query:

mysql_query("SELECT *,date_format(pm_message_date, '%D %b') AS date_2 FROM pm_messages WHERE pm_project_id = '" . $_SESSION['project_info']['2'] . "' AND pm_message_date BETWEEN (CURDATE() - INTERVAL 1 DAY) AND (CURDATE() - INTERVAL 1 SECOND)")

Can anytell tell me what this does exactly?
As i understand it it is getting fron the database only those rows that have yesterdays date...is this correct?

If not, can anyone tell me how to change this to do so.

Also, how can i modify this to make another query that will retrieve everything that is is before yesterdays date...therefore every row after yestersays date.

Any help much appreciated.
Cheers,
macca

[mrhappiness]

it should give you yesterday's dates but i personally prefer

pm_message_date BETWEEN CURDATE() - INTERVAL 1 DAY AND CURDATE()

the other things

pm_message_date < CURDATE() - INTERVAL 1 DAY
or
pm_message_date > CURDATE() - INTERVAL 1 DAY

look at it and take the one that is suitable