mysql+下周,mysql仅选择下周数据

I have a date field in my database i.e film_release_date.

So what is mysql query to fetch the next week data from table.

I run this query but its not working properlly.

SELECT

*,

DATE_FORMAT(film_release_date,'%e-%b-%Y') AS release_date

FROM gf_film

WHERE

MONTH(film_release_date)=MONTH(CURRENT_DATE)

AND YEAR(film_release_date)=YEAR(CURRENT_DATE)

AND film_release_date>=(CURRENT_DATE)

ORDER BY film_release_date DESC

Actually its for movie website i have several movies in my database so i need a query which fetch every next week movie that means movies that will release in next week means next friday.If i run this today i.e 13 then it shows all movies between 15 to 22 and if run this between 15 to 22 then it shows data from 22 to 29

解决方案set @d := date_add(CURRENT_DATE, interval 7 day);

set @week_start := @d - interval (dayofweek(@d) + 1) day;

set @week_end := @d + interval (6 - dayofweek(@d)) day;

SELECT *,

DATE_FORMAT(film_release_date,'%e-%b-%Y') AS release_date

FROM gf_film

WHERE film_release_date between @week_start and @week_end

ORDER BY film_release_date DESC