title: Using exclusive or in mysql
body: <p>I have a table as below</p>
  
  <p>Table foobar</p>
  
  <pre><code>|foo|bar|
  ---------
  | 1 | 1 |
  | 1 | 0 |
  | 0 | 1 |
  | 0 | 0 |
  </code></pre>
  
  <p>I need to be able to do something similar to this</p>
  
  <pre><code>select * from foobar
  where foo = 1 or bar = 1
  </code></pre>
  
  <p>Which would return the below</p>
  
  <pre><code>|foo|bar|
  ---------
  | 1 | 0 |
  | 0 | 1 |
  </code></pre>
  
  <p>Meaning that what is returned is exclusively 1 for the value. Is there such a thing as XOR in mysql that functions like this?</p>