User Tools

Site Tools


reference:spamrules_db_comparator

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
reference/spamrules_db_comparator.txt · Last modified: 2018/11/14 10:45 (external edit)