<p>I want to do a select in MySql that combines several columns... something like this pseudocode:</p>

<pre><code>SELECT payment1_paid AND payment2_paid AS paid_in_full 
FROM denormalized_payments 
WHERE payment1_type = 'check';
</code></pre>

<p><strong>Edit</strong>: payment1_paid and payment2_paid are booleans.</p>

<p>I can't use any other language for this particular problem than MySql.</p>

<p>Thanks for any help!</p>

<p><strong>Edit</strong>: Sorry to everybody who gave me suggestions for summing and concatenating, but I've voted those early answers up because they're useful anyway. And <strong>thanks</strong> to everybody for your incredibly quick answers!</p>

Just do
```
```
Select CONCAT(payment1_paid, payment2_paid) as paid_in_full 
from denormalized_payments 
where payment1_type = 'check';
```
```
You can concat any number of field you want.