Skip to content

Instantly share code, notes, and snippets.

@remvee

remvee/gist:271245

Created January 7, 2010 14:15
Show Gist options
  • Save remvee/271245 to your computer and use it in GitHub Desktop.
Save remvee/271245 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL EXISTS vs IN
Raw
gistfile1.txt
# MySQL basic ..IN (SELECT..
SELECT * FROM foos WHERE foo IN (SELECT foo FROM bars);
# can be rewritten to the much faster:
SELECT * FROM foos WHERE EXISTS (SELECT 1 FROM bars WHERE bars.foo = foos.foo);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment