title: Sum values of a single row?
body: <p>I have a MySQL query that returns a single row that is a series of 1s and 0s. It's for a progress bar indicator. I have the summing of it in code now, but I tried to sum the values in a query, and realized I couldn't use SUM(), because they're many columns but just one row. </p>
  
  <p>Is there a way I can sum this automatically in the query? It's like this:</p>
  
  <pre><code>item_1 | item_2 | item_3 | item_4
  -------+--------+--------+--------
       1 |      1 |      0 |      0
  </code></pre>
  
  <hr>
  
  <p>Edit: I forgot to mention, <code>item_1</code> and so forth are not simple field values, but each is rather an expression, such as <code>SELECT IF( field_1 = 1 and field_2 IS NOT NULL, 0, 1 ) AS item_1 ...</code>, so it looks like I have to do a nested query:</p>
  
  <pre><code>SELECT ( item_1 + item_2 ... ) FROM ( SELECT IF( field_1 = y and field_2 IS NOT NULL, 1, 0 ) AS item_1 ... ) AS alias
  </code></pre>
  
  <p>Correct?</p>