SQL Usefull Querys

1. Select data between CURRENT date AND 30days before date
select * from db_movie m where m.rel_date between adddate(now(),-30) and now()


1. Select data between CURRENT date AND 30days AFTER date
select * from db_movie m where m.rel_date between now() and adddate(now(), 30)