How to correctly form a query to mysql?

Question

MySQL

There is an array of View IDs [123321, 154874, 12233] and so on.
There is a basis in which these ID are written down. How can I make a request to the database so that only those IDs that are not in the database are returned to me?

Answer 1

SELECT * FROM tablename WHERE id NOT IN (123321, 154874, 12233)

Answer 2

Select * From xxx Where xxx.id NOT IN (123321, 154874, 12233);
At a large number of records there will be brakes still those.

Answer 3

MySQL? Uncomfortable.

select /**/ from (
    select 123321 as id
    union all
    select 154874
    union all
    select 12233
) as targets
where not exists (
    select 1 from tablename where tablename.id = targets.id
);