title: sqlite if no rows returned print 0
body: <p>I have the following query:</p>
  
  <pre><code> SELECT user_tag, device_type,  ip_address
  
   FROM
   devices 
  
   WHERE (user_tag like '|%frt%|'
   OR user_tag like '|%bck%|'
   OR user_tag like '|%ppp%|'
   OR user_tag like '|%smes%|'
   OR user_tag like '|%gm%|')
  </code></pre>
  
  <p>Right now if a record is only returned for the user_tag 'frt' I only receive one row (as you would expect). Is there a way to set a default value for the blank rows, so for example I would receive a value of '0' or something similar for the rows that don't return any real data?</p>