The IN operator is shorthand for many OR conditions. The BETWEEN operator allows you to define a range to which the given value belongs. The NOT operator can be added to a WHERE clause to negate the condition that is placed after it. The LIKE operator checks whether the specified string matches a defined pattern.
Sort: