title: How to select a random row with a group by clause?
body: <p>I have the following table</p>
  
  <p><a href="http://sqlfiddle.com/#!2/7dbf1e/4" rel="noreferrer">SQLFiddle</a></p>
  
  <p>What I'm attempting to do is to select three random images but to make sure that no two images have the same object, what I attempted to do is to do a GROUP BY along with an ORDER BY rand() but that is failing as it is always giving me cat1.jpg, dog1.jpg, box1.jpg (All images whose path ends with 1 and not the others) </p>
  
  <p>The fiddle includes the query I ran and how it is not working.</p>