MySQL query help

[artie2004]

Hi. First, how do i query all records for the current date? Second, how do i query all records from the previous day?

i.e. this is my table

table clients (
name char(25),
cid char(8),
email char(25),
tel char(10),
date datetime
);

Thanks.

[coopster]

SELECT * FROM clients WHERE `date` = CURRENT_DATE; 
SELECT * FROM clients WHERE `date` = CURRENT_DATE - INTERVAL 1 DAY;

Side note:
If at all possible you shouldn't name a column the same as a reserved word (in this case your

date

column).

[artie2004]

thanks coopster.