WEEKDAY() function to get number from 0 to 6 based on Weekday in MySQL

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