title: Return "true" if two columns in record are equal?
body: <p>I'm looking for an possibility to check in an sql statement if various columns equal each other and return true or false:</p>
  
  <p>For Example: 4 Columns (a,b,c,d)  and I want to check if a LIKE b and c LIKE d and if true then return true(or 1)...</p>
  
  <p>Is this possible to do this in mysql? i'm actually solving this with php in 2 steps but this sucks..</p>
  
  <p>thx for your advice</p>