Getting value depedning on two boolean attrinutes.[Nested ifs]
- by uswaretech
I have two fields
start_time
end_time - can be null
Now, depending on this I needs to differentiate between three states
Scheduled in future,
Currently running
Completed in past
Since mysql IF operator can not be nested, (Or I cant find an easy way to nest them), I cant find how to get the three state status.