title: MySQL - Only Select certain rows depending on different conditions
body: <p>So, I've already asked a questoin similar to this <a href="https://stackoverflow.com/questions/59907704/mysql-ignore-certain-rows-depending-on-different-conditions/59908260#59908260">here</a>  but I'll ask again since what I need is similar to that but with a different conditions.</p>
  
  <p>As an example I have a <code>Pokemon</code> column with certain data inside, many of them repeat</p>
  
  <p>Pokemon</p>
  
  <pre><code>Mega Blastiose
  Blastoise
  Mega Charizard
  Mega Venusaur
  Pichu
  Pikachu
  Alakazam
  Pichu
  Kadabra
  Squirtle
  Wartotle
  Wartotle
  Diglett
  </code></pre>
  
  <p>What I need is to select only certain data, if a specific data on the same <code>column</code> exists. Certain data from the <code>pokemon</code> column must exists before I fetch data via <code>SELECT</code></p>
  
  <p>What I want is something is a query that do something like this but on multiple data. </p>
  
  <pre><code>SELECT * FROM table 
  (
      If Pichu doesn't exists then don't SELECT Pikachu
      If (Abra OR Kadabra) doesn't exists then don't SELECT Kadabra
      If (Squirtle OR Wartotle OR Blastoise) doesn't exists then don't SELECT Mega Blastoise
      If Pidgety doesn't exists then don't SELECT Pidgeotto
      If (Charmarder OR Charmeleon OR Charizard) doesn't exists then don't SELECT Mega Charizard
      If (Bulbasaur OR Ivysaur OR Venusaur) doesn't exists then don't SELECT Mega Charizard
  )
  </code></pre>
  
  <p>So the final result of the <code>SELECT</code> query I need would result in something in this.</p>
  
  <pre><code>Mega Blastiose
  Blastoise
  Pichu
  Pikachu
  Alakazam
  Pichu
  Kadabra
  Squirtle
  Wartotle
  Wartotle
  Diglett
  </code></pre>
  
  <p>It ignored, Mega Charizard &amp; Mega Venusaur since they are the only data that didn't meet their condition while fetching everything else.
  I know it's a bit confusing request but it's the query I'm looking for</p>