title: MYSQL - How do I show 0 is there are no results?
body: <p>I have the below query which is working fine and shows any missed calls on a dashboard. However if there are no results it returns no data. How do I show '0' is there are no results? Thanks</p>
  
  <pre><code>SELECT DialledNumber, COUNT(*) As Missed
  FROM CALLS
  WHERE destination like '%!%' AND datetime BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 1 day)
  GROUP By DialledNumber
  HAVING (DialledNumber = '500') OR (DialledNumber = '580') OR (DialledNumber = '515') OR (DialledNumber = '513') OR (DialledNumber = '514')
  </code></pre>