title: MySQL : Make HAVING select also "null"
body: <p>I have two tables : <code>dilemme</code> and <code>like</code>. The first one contains articles and the second one contains votes. The script SELECT randomly one article to show and the user can vote (it's like and dislike).</p>
  <p>I want to make a query that shows only the articles that have more than - 5 voting, the articles that has no vote are equal to 0.</p>
  <p>So I tried this :</p>
  <pre><code>SELECT d.ph1, d.ph2, d.id, SUM(l.vote) AS score
  FROM dilemme d
  LEFT JOIN like l
  ON d.id = l.id_dilemma
  WHERE d.valid = 'yup'
  GROUP BY d.id HAVING SUM(l.vote) &gt; 0
  </code></pre>
  <p>It shows me correctly the rows that have at least one vote and that the sum of the votes are more than 0. Which is nice but, how to select also articles without vote ?</p>
  <p>I tried a bunch of things and did some research but can't fix my problem.
  I thought about INSERT INTO like a vote of 0 but I don't think its a good idea since it won't be very an optimized solution.</p>