title: how To get date greater then or equal to today from day name (Sunday,Monday,etc) in mysql select query
body: <p>if today date is 14-07-2016 and day name is Thursday</p>
  
  <p>if day name in column of table is monday then query should return date is 18-07-2016 (Beacuase Todaye is Thursday.)</p>
  
  <p>if day name in column of table is
  Day is Tuesday then date is 19-07-2016 ,
  if
  Day is Wednessday then date is 20-07-2016
  if 
  Day is Thursday then date is 14-07-2016
  if
  Day is Friday then date is 15-07-2016
  if
  Day is Saturday then date is 16-07-2016
  if 
  Day is Sunday then date is 17-07-2016</p>
  
  <p>I have Used This Query</p>
  
  <pre><code>SELECT *, STR_TO_DATE(CONCAT(YEAR(NOW()),WEEK(NOW(),1), weekday), '%X%V %W') as edate, From table_event
  </code></pre>
  
  <p>In this Query 
  it work fine but it return past date and i don't need past date i need only future dates</p>
  
  <p>so please guide me for it ASAP.
  Thanks In Advance</p>