From: Daevid Vincent
Date: November 10 2006 7:48am
Subject: ORDER BY RAND() gives me duplicate rows sometimes
List-Archive: http://lists.mysql.com/mysql/203256
Message-Id: <002101c7049c$9f6e6550$450a0a0a@locutus>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

I am using this query to pull three random comments from a table:

"SELECT *, DATE_FORMAT(created_on, '%b %D') as date_format FROM comments
ORDER BY RAND() LIMIT 3";

The problem is that sometimes, I get two of the same comment. How can I
refine this query to give me 3 unique/distinct ones?