Statement | DBDeleteTime |
---|---|
Version | 6.16+ |
Purpose | Deletes records from the spam filter database based on their last update time |
The DBDeleteTime statement requires a component name, comparator and time value, in the format
DBDeleteTime <component name> <comparator> <timevalue>
Example
DBDeleteTime subject < "3 months"
This will delete all records for the 'subject' component which were last updated earlier than 3 months ago.
The SQL expression is created as 'updatetime <comparator> now() - <timevalue>', so the above statement's query string becomes where updatetime < now() - '3 months'