title: How do I do boolean logic on two columns in MySql, one of which is a Varchar?
body: <p>This is the sequel to <a href="https://stackoverflow.com/questions/248683/how-can-i-do-boolean-logic-on-two-columns-in-mysql">this question</a>.</p>
  
  <p>I would like to combine three columns into one on a MySql select. The first two columns are boolean and the third is a string, which is sometimes null. This causes strange results:</p>
  
  <pre><code>Select *, (payment1_paid &amp;&amp; ((payment2_paid || payment2_type ="none"))) as paid_in_full from payments 
  </code></pre>
  
  <p><strong>Note:</strong> <code>payment1_paid</code> is boolean, <code>payment2_paid</code> is boolean, <code>payment2_type</code> is varchar.</p>
  
  <p><strong>Note:</strong> Please ignore how ridiculous the structure of this table is. Behind every piece of bad code there is a long explanation :)</p>
  
  <p><strong>Edit:</strong> Null is not interesting to me for the varchar value. I only want to know if it's really "none."</p>
  
  <p>Thanks in advance for your help!</p>