title: MySQL Multiple SELECT queries with different WHERE clause on the same table
body: <p>I need some help on a MySQL query that I am trying to build.</p>
  
  <p>The is the table I have:</p>
  
  <pre><code>+----+-----------+---------+-----------+---------+------------+-----------+
  | id |  fruit    | color   |  shape    | country |    vit     |   city    |
  +----+-----------+---------+-----------+---------+------------+-----------+
  | id |  Apple    | red     | spherical | UK      |     A      | London    |
  | id |  Orange   | orange  | circular  | USA     |     C      | New York  |
  | id |  Apple    | green   | multiple  | Mexico  |     C      | Cancun    |
  | id |  Apple    | red     | spherical | Canada  |     B      | Ottawa    |
  +----+-----------+---------+-----------+---------+------------+-----------+
  </code></pre>
  
  <p>Now I want to use one query to perform multiple <code>SELECT</code> queries like so:</p>
  
  <pre><code>SELECT * from tbl_fruits WHERE fruit = "Apple" AND vit = "A" AND city = "London";
  SELECT * from tbl_fruits WHERE fruit = "Apple" AND vit = "B" AND city != "London;
  SELECT * from tbl_fruits WHERE fruit = "Apple" AND vit != "A" AND vit != "B" AND city != "London";
  </code></pre>
  
  <p>The resulting table would be:</p>
  
  <pre><code>+----+-----------+---------+-----------+---------+------------+-----------+
  | id |  fruit    | color   |  shape    | country |    vit     |   city    |
  +----+-----------+---------+-----------+---------+------------+-----------+
  | id |  Apple    | red     | spherical | UK      |     A      | London    |
  | id |  Apple    | green   | multiple  | Mexico  |     C      | Cancun    |
  | id |  Apple    | red     | spherical | Canada  |     B      | Ottawa    |
  +----+-----------+---------+-----------+---------+------------+-----------+
  </code></pre>
  
  <p>In order for all of this to make sense as to why, I need to get all results for Apple with the first <code>SELECT</code> limiting on three conditions. Then I need to get all results for Apple with the second <code>SELECT</code> but this time limiting only on two conditions AND excluding the results from the first <code>SELECT</code> and so on.</p>
  
  <p>Any idea how to achieve this? I tried several different queries, including <code>UNION</code> but somehow cannot get it to display the results I need.</p>