mysql seelct date between now and this week code example Example: mysql date of the week DAYOFWEEK(date)