DAYOFWEEK() function to get number from 1 to 7 based on Weekday in MySQL

By using any dayofweek() we will get integer from 1 to 7 based on the weekday of the input date.
We will get 1 for Sunday, 2 for Monday, 3 for Wednesday, 4 for Thursday, 5 for Friday, 6 for Saturday
SELECT DAYOFWEEK(‘2020-09-21’);
We can get todays day number l by using CURDATE() function
SELECT DAYOFWEEK(CURDATE());
We can also get yesterday day number
SELECT DAYOFWEEK(CURDATE()-INTERVAL 1 DAY);
Next day number
SELECT DAYOFWEEK(CURDATE() + INTERVAL 1 DAY);
Previous day number , todays number and tomorrow day number
SELECT DAYOFWEEK(CURDATE()- interval 1 DAY) as yesterday,
DAYOFWEEK(CURDATE()) as today,
DAYOFWEEK(CURDATE()+ INTERVAL 1 DAY) as Tomorrow