LIKE for pattern matching. This must be used in conjunction with the wildcard characters % (for a wildcard with a variable number of letters) or _ (for a wildcard single letter). For example, the restriction
LIKE \_ake% would return true for
Jake Smith, or
Fake Smith. It would return false for
NOT LIKE is similar to pattern matching above, but checks for which patterns do not match.
IS checks if the column is
NULL, or empty.
IS NOT is similar to the
IS operator above, but checks for non-NULL columns.
IN checks for a value’s presence in a comma-separated list. (for example, “Color
IN red,orange” is the equivalent of color
equal to red OR color
equal to orange).
NOT IN is similar to
IN above, but checks for a value’s absence.