title: Mysql Left Join Null Result
body: <p>I have this query</p>
  
  <pre><code>SELECT articles.*, 
         users.username AS `user` 
   FROM `articles` 
  LEFT JOIN `users` ON articles.user_id = users.id 
   ORDER BY articles.timestamp 
  </code></pre>
  
  <p>Basically it returns the list of articles and the username that the article is associated to. Now if there is no entry in the users table for a particular user id, the <code>users</code> var is NULL. Is there anyway to make it that if its null it returns something like "User Not Found"? or would i have to do this using php?</p>