How to extract the day of week of a given date using the DAYOFWEEK() function?

DAYOFWEEK(date) is a MySQL built-in function that returns the day of week from a given date. For example:

SELECT DAYOFWEEK('2023-02-03'), DAYNAME('2023-02-03');
  -- +-------------------------+-----------------------+
  -- | DAYOFWEEK('2023-02-03') | DAYNAME('2023-02-03') |
  -- +-------------------------+-----------------------+
  -- |                       6 | Friday                |
  -- +-------------------------+-----------------------+

SELECT DAYOFWEEK(NOW()), DAYNAME(NOW());
  -- +------------------+----------------+
  -- | DAYOFWEEK(NOW()) | DAYNAME(NOW()) |
  -- +------------------+----------------+
  -- |                3 | Tuesday        |
  -- +------------------+----------------+

Reference information of the DAYOFWEEK() function:

DAYOFWEEK(date): int
  Returns the weekday index for date (1 = Sunday, 2 = Monday, ...,
  7 = Saturday).

Arguments, return value and availability:
  date: Required. The date to extract the day of week from.
  int: Return value. The day of week.
  Available since MySQL 4.

Related MySQL functions:

• DAYNAME() - Name of Weekday
• DAYOFMONTH() - Day of Month
• DAYOFYEAR() - Day of Year
• WEEKDAY() - Weekday (0=Monday)

⇒ DAYOFYEAR() - Day of Year

⇐ DAYOFMONTH() - Day of Month

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References