选择表中不存在的列表值

Question

I have a list of values in my PHP code. We could say:

$myList = array("one", "two", "three")

I'd like to select the values of the array that not exists in a table.

I've tried something similar to this:

SELECT *
FROM (my-list-here)
WHERE
    NOT EXISTS (
        SELECT * FROM my_table WHERE value IN (my-list-here)
    )

I don't know how to select values from that array :(

Answer 1

I don't know if we can really execute a SQL query for an array and not a table like you've done

SELECT *
FROM (my-list-here)
WHERE...

What you can do is get the array of the values from the table using query and use array_diff to remove the values that exists in the $myList array.