| ID | date_start | date_end | DisplayStatus |
| ID | date_start | date_end | DisplayStatus
| 1 | 2015-10-01 | 2015-10-18 | E |
| 1 | 2015-10-01 | 2015-10-18 | E
| 2 | 2013-10-28 | 2013-10-31 | F |
| 2 | 2013-10-28 | 2013-10-31 | F
hello everbody
i want to ask how can i to do match to column date_start and date_end if now < date_start or date_end < now displaystatus updated F also
now is >= date_start and date_end > now displayStatus also updated E
how can i write sql query ?