hmmm i was trying it and i got an error saying "FROM keyword not found where expected"... my query is:
SELECT *, CASE WHEN (SYSDATE < EXPIRATION_DATE) THEN 'not_expired' ELSE 'expired' END as is,_expired FROM db.tablename .... it seems to work without the "*," but i'd like other columns as well. Some pages indicate getting other columns is valid i think. did i goof somewhere.
let me rerun hehe
so it works without the '*,' but id like to do this is 1 query... have that boolean and have the other columns.