LIKE for pattern matching. This must be used 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 Stein, Jake Smith, or Fake Smith. It would return false for Drake Smith.
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.