I would like to create a table that one of it's fields is calculated according to other fields. Is there a way to do it?
For example:
Field a - expirationDate
Field b - isDeleted
Field c should be the status and calculated as follows: if isDeleted=1 should be "deleted" if expirationDate < NOW() should be "expired" else should be "active".