SQL IN

IN operator can select multiple values in a WHERE clause

IN SQL Syntax

SELECT column FROM table WHERE column IN (value1, value2, value3, ...)

Example SQL IN

Given the following table 'people'

namesurnamenickname
HARRYCLARKWHITE
HARRYSMITHJOHNSON
JOHNBROWNANDERSON

We select the people whose surname is 'CLARK' or 'BROWN'

SELECT * FROM people WHERE surname IN ('CLARK', 'BROWN')
namesurnamenickname
HARRYCLARKWHITE
JOHNBROWNANDERSON