How to create a MySQL statement to check expiry and and deactivate a/c on matched date?
desc mailbox;
username varchar
pass varchar
created datetime
expiry datetime
active tinyint(1)
I need to expire a/c (username filed) on expiry date which should be active=0