Get integer which is not in database
<p>I have this MySQL table :</p>

<pre><code>create table example (
    My_Id      INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    My_Integer INT UNSIGNED DEFAULT 0
) ENGINE=InnoDB
</code></pre>

<p>Suppose this table to be populated like that : </p>

<pre><code>SELECT * FROM `example`

My_Id   My_Integer
1       10
2       1
3       3
4       152
5       16
6       481
7       128
</code></pre>

<p>My goal is to retrieve, from an user input, which integer is not in my table 'example'.</p>

<p>For example, if the user enter 1, 3, 10, the result should be empty.
If the user enter 1, 2, 3, 10, the result should be "2".</p>

<p>I can't find a way to do that, other than to do one MySQL request per integer in order to know if the number is in the table 'example'.
Do someone know a way ?</p>