title: How can I do boolean logic on two columns in MySQL?
body: <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>