MySQL DAYOFWEEK() – my week begins with monday April 26, 2023 by Tarik Use WEEKDAY() instead of DAYOFWEEK(), it begins on Monday. If you need to start at index 1, use or WEEKDAY() + 1.