AND, OR, NOT

AND, OR and NOT combine several conditions. AND takes precedence over OR and you should use parentheses to express the intent, for example to group alternatives. Mixing them without parentheses is a frequent source of unexpected results.

Example

WHERE pays = 'FR' AND (statut = 'actif' OR vip)

Related concepts

The whole glossary