SQL select from data in query where this data is not already in the database?
Posted
by Michael
on Stack Overflow
See other posts from Stack Overflow
or by Michael
Published on 2010-04-05T19:59:19Z
Indexed on
2010/04/05
20:03 UTC
Read the original article
Hit count: 209
mysql
|mysql-query
I want to check my database for records that I already have recorded before making a webservice call.
Here is what I imagine the query to look like, I just can't seem to figure out the syntax.
SELECT FROM (1,2,3,4) WHERE id NOT IN table.id
Is there a way to do this? What is a query like this called?
© Stack Overflow or respective owner