Spamfilter database comparators

Several Spamfilter DB statements allow comparators which are listed below

If the value specified in the statement is numeric:

• = or == compare numeric values for equality
• <> or != compare numeric values for inequality
• <, >, ⇐, >= do standard numeric comparisons

If the value specified in the statement is non-numeric:

• = or == compare string values for equality using plain ASCII comparisons
• <> or != compare string values for inequality using plain ASCII comparisons
• <, >, ⇐, >= do string comparisons using plain ASCII comparisons
• A '*' after each of the above comparators makes them case insensitive (eg ==* )

Whether or not the value specified in the statement is numeric:

• eq compares string values for equality using plain ASCII comparisons
• ne compares string values for inequality using plain ASCII comparisons
• lt does a 'less than' string comparison using plain ASCII comparisons
• le does a 'less than or equals' string comparison using plain ASCII comparisons
• gt does a 'greater than' string comparison using plain ASCII comparisons
• ge does a 'greater than or equals' string comparison using plain ASCII comparisons
• An 'i' after each of the above comparators makes them case insensitive (eg nei)
• ~ does a POSIX regular expression match comparison
• !~ does a POSIX regular expression not-match comparison
• ~* does a case insensitive POSIX regular expression match comparison
• !~* does a case insensitive POSIX regular expression not-match comparison
• LIKE does an SQL 'LIKE' comparison
• ILIKE does a case insensitive SQL 'LIKE' comparison