title: How do I compare two columns in the same table?
body: <p>I would like to compare two columns in the same table.  I want to be able to return all rows where the two columns have the same value.</p>
  
  <p>I am looking for something like <code>SELECT * FROM FOO WHERE C1 = C4</code>.</p>
  
  <p>Therefore in the example below I would return only the first row:</p>
  
  <pre><code>C1    || C2  || C3  || C4
  --------------------------
  1     || a   || b   || 1
  2     || a   || b   || 4
  3     || b   || d   || 2
  4     || b   || d   || 2
  </code></pre>
  
  <p>If it matters, I am using <code>SQLite</code> (more specifically <code>WebSQL</code>).</p>