Skip to content

Instantly share code, notes, and snippets.

@csdear

csdear/~CherryPick ~ Select Multiple.sql

Last active December 15, 2015 19:40
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save csdear/54e6d8811ce6369ad5c5 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save csdear/54e6d8811ce6369ad5c5 to your computer and use it in GitHub Desktop.
Download ZIP
Select Multiple ~ CherryPick ~
Raw
~CherryPick ~ Select Multiple.sql
--Can do this the long way with OR
SELECT * FROM apples
WHERE appleID = '5544' OR appleID = '5978'OR appleID = '1586' OR appleID = '4592'
--more efficient, using the IN keyword.
select * from modem where sn in ('1234', '4564', '4568', '1239')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment