title: mysql: get a row for every matching condition even with the same record
body: <p>I know this is weird (maybe?) But how do I get multiple rows for the same record, relative to how many condition it passed?</p>
  
  <pre><code>table foo
  +----------+-------+
  | field1   |field2 |
  +----------+-------+
  | 1        | 0     |
  +----------+-------+
  
  SELECT field1
  FROM foo
  WHERE field1 = 1 OR field2 = 0
  </code></pre>
  
  <p>I want it to return</p>
  
  <pre><code>+----------+
  | field1   |
  +----------+
  | 1        |
  | 1        |
  +----------+
  </code></pre>