Greetings guys I need help with the following:
I have a table with more data than 6000 data and I need to make a query in phpmyadmin where I will provide a data packet to look for and this will tell me what data I am looking for do not exist.
What I Have
With the following structure gives me as a result of the block of data supplied those that are example if I am looking for 200 data I realize that there is already data that exists because it shows me as a result a total of 180 that is there are 20 that do not exist, and I require determine which of the supplied serials are those that do not exist and I do not know how to generate the SQL statement for it.
SELECT serial FROM tarjetas WHERE serial IN ('a','b','c','d','e','f','g','h'......)
SELECT serial, ISNULL(serial,'NO EXISTE') AS No_Existe.....
But I get an error.
It is worth mentioning that among the data that I am consulting many of them are already in the table, and I need to know which ones do not are in the table.
An Example of what I require
If I have the data:
And my query is to find the serials
('c','d','e','f') enlisted that the serials
d, e y f are those that do not exist because the serial
c if it exists in my table.