IN tests membership in a list of values, BETWEEN tests a range, bounds included, and LIKE compares against a text pattern with % (sequence of characters) and _ (one character). They make filters shorter than a series of comparisons.
Example
WHERE pays IN ('FR', 'BE') AND nom LIKE 'Du%'