Ekrem Tapan

Ekrem Tapan

  • NA
  • 967
  • 77.8k

Update Sql Column

Oct 2 2015 2:58 AM
| ID | date_start  |  date_end  | DisplayStatus |
| 1  | 2015-10-01  | 2015-10-18 |       E       |
| 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 ?  

Answers (3)