title: MySQL sum of two COUNT statements
body: <p>I know this has a stupid solution but, sorry, I'm little bit confused.</p>
  
  <p>I have two SELECT COUNT statements. Example:</p>
  
  <p><em>Statement 1</em></p>
  
  <pre><code>SELECT COUNT(softwareone) AS totalcount 
  FROM my_table WHERE softwareone LIKE '%typeone%'
  </code></pre>
  
  <p>totalcount = 3
  _</p>
  
  <p><em>Statement 2</em></p>
  
  <pre><code>SELECT COUNT(softwaretwo) AS totalcount 
  FROM my_table WHERE softwaretwo LIKE '%typeone%'
  </code></pre>
  
  <p>totalcout = 1</p>
  
  <p>I want to sum both totals to get totalcount = 4. There is a way to do that?</p>
  
  <p>Note: software type from columns "softwareone" and "softwaretwo" is of the same type (same value).</p>
  
  <p>Thanks to all.</p>