title: MySQL LEFT JOIN filtering rows where NULL
body: <p>I am attempting to return whether a user has favourited an item or not. I have the MySQL statement:</p>
  
  <pre><code>SELECT *,`user_choice`.fav FROM `items`
  LEFT JOIN `user_choice` ON `user_choice`.item_id = `items`.item_id
  </code></pre>
  
  <p>This returns a full set of results, with <code>user_choice</code>.fav equal to 0, 1 or NULL</p>
  
  <p>However, I would like to only show the <code>user_choice</code>.fav (whatever that value may be) for a given user, so I have added a <code>WHERE</code> statement for that user like so:</p>
  
  <pre><code>SELECT *,`user_choice`.fav FROM `items`
  LEFT JOIN `user_choice` ON `user_choice`.item_id = `items`.item_id
  WHERE `user_choice`.user_id=xx
  </code></pre>
  
  <p>When I add this WHERE statement, it filters out any results from the first statement where <code>user_choice</code>.fav is NULL (ie not 1 or 0). How can I get it to return values even when they are NULL</p>
  
  <p>example data:</p>
  
  <p><code>items</code></p>
  
  <h2>item_id | item_name</h2>
  
  <p>1,itemname</p>
  
  <p>2,item2name  </p>
  
  <p>3,item3name      </p>
  
  <p><code>user_choice</code></p>
  
  <h2>user_id | item_id | fav</h2>
  
  <p>1,1,1</p>
  
  <p>1,3,0</p>