title: Mysql get values missing in the In Clause
body: <p>I want to get values missing in the in clause of a query</p>
  
  <p>people</p>
  
  <pre><code>ID    |  Name | location_id | 
  1     |    Rex|          5  |
  2     |    Tex|          7  |
  3     |    Jim|          8  |
  4     |   John|          11 |
  5     |    Tom|          12 |
  </code></pre>
  
  <p>Place</p>
  
  <pre><code>location_id | Place    |
  5           | New York |
  6           | London   |
  7           | Madrid   |
  8           | Paris    |   
  9           | Dublin   |   
  10          | Chicago  |   
  11          | Berlin   |   
  12          | Colombo  |   
  </code></pre>
  
  <p>i want to find places where there are no people , when i give a list of locations in the in clause of the Query</p>
  
  <p>i don't want to find all the locations which are not in the people table, only those ,in which i provide in the in clause</p>
  
  <p><strong>Query</strong>  </p>
  
  <pre><code>SELECT location_id FROM people WHERE location_id in (5,6,7,8,9);
  </code></pre>
  
  <p>OUTPUT expected </p>
  
  <pre><code>|Location_id|
             6|
             9|
  </code></pre>