title: Filter in mysql query
body: <p>I have a <code>mysql</code> table for my records like</p>
  
  <pre><code>id int(11) | name varchar(255) | status enum('Yes', 'No', 'Nil') | type enum('auto', 'manual') | 
  </code></pre>
  
  <p>I need a query to show all the records with manual type regardless of their status and all other records whose status is set as Yes</p>