Skip to content

Glossary: SQL Basics

IN

Also written: NOT IN

A condition true when a value matches any item in a list, such as `state IN ('OR', 'WA')`; a shorter form of several ORs. NOT IN does the opposite.

Where the book teaches it

Related terms

AND / OR / NOTBETWEEN