<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>

I guess you want NULL to be false? Try
```
(payment_paid IS NULL || payment2_type = "none")
```