Getting mysql result from the last 30 days

select * from table
where date between date_sub(now(), interval 30 day) and now();