SQL query: how to select records in the range from today to the end of the week?

Question

PHP

There is a table with attribute "date". I need to get from this table only those records that are in the range from today to the end of the week.
Found a similar query

Answer 1

....
 WHERE `date` BETWEEN CURDATE() 
              AND DATE_ADD(CURDATE(), INTERVAL 7-WEEKDAY(CURDATE()) DAY)

Answer 2

SELECT * FROM `table` WHERE STR_TO_DATE(`date`, '%d.%m.%Y') >= CURDATE() AND STR_TO_DATE(`date`, '%d.%m.%Y') <= CURDATE() + INTERVAL 7 DAY

Answer 3

If you need any other day of the week, then replace 8 with another number.

SELECT * 
FROM `table`
WHERE (`data` >= DATE(NOW()) AND 
       `data` <= DATE (DATE('Y-m-d') + INTERVAL (8 - DAYOFWEEK(DATE('Y-m-d'))) DAY));