I'd like to issue a command to a database our team manages to clean all data older than 30 days.
Browsing around I've found that:
DELETE FROM $table WHERE $timestamp < NOW() - INTERVAL 30 DAY
could work, but I'd like to check with you first just in case you have a better command or ideas.
Thanks in advance for your help.
Best regards, M.