title: Is there a way to merge boolean value fields in MySQL?
body: <p>I have a table that contains several fields with Boolean values.</p>
  
  <p>I need 3 of the fields to be merged into one only if all 3 of them are true. </p>
  
  <p>I was thinking about a <code>JOIN</code>, but it looks like it cannot do what I need. </p>
  
  <pre><code>------------------------------------------------------------
  | Email address| permission1 | permission2 | permission3
  ------------------------------------------------------------
  | test@test.com|     1       |      0      |      1
  ------------------------------------------------------------
  | test2@test.com|     1      |      1      |      1
  ------------------------------------------------------------
  </code></pre>
  
  <p>I would expect a result, perhaps in a new table to look like this:</p>
  
  <pre><code>--------------------------------
  | Email address| permissionMerge 
  --------------------------------
  | test@test.com|     0       | 
  --------------------------------
  | test2@test.com|     1      | 
  --------------------------------
  </code></pre>