Mysql week from Monday till Sunday

Hi,

I created a query to get the date for the week, but now I noticed that the date was from Sunday to Monday.
How can I start it from Monday to Sunday.

Here is my query:


SELECT DISTINCT r.report_date, r.process_id
    FROM op_reports AS r
    JOIN shift_list AS s ON (s.shift_id = r.report_shift)
    JOIN process_list AS p ON (p.process_id = r.process_id)
    WHERE WEEK(report_date) = '30'
    GROUP BY r.report_date ORDER BY r.report_date  ASC;

Thank you so much.

please go to the manual and look up the WEEK() function

Thanks

I resolved it now using this query:

SELECT DISTINCT r.report_date, r.process_id
FROM op_reports AS r
JOIN shift_list AS s ON (s.shift_id = r.report_shift)
JOIN process_list AS p ON (p.process_id = r.process_id)
WHERE WEEK(report_date, 1) = ‘30’
GROUP BY r.report_date ORDER BY r.report_date ASC;