php - Mysql date problem -


i have date field in db.

  1. i want data between saturday sunday , monday .
  2. of data want 1 record record date next coming date

hope make self clear

select dayofweek(date) wd table wd > 1 , wd < 6 , date >= current_timestamp() order date asc limit 1; 

Comments