Hi,
while I can not help you with your direct question, I don't know of a
way to order randomly and select one you hadn't selected yet in SQL,
there is another way to do this.
With your UNION query your already executing two 'expensive' queries,
the entire table get's ordered (twice) before the
-Original Message-
From: maarten [mailto:maarten.fo...@edchq.com]
Sent: Thursday, April 29, 2010 10:23 AM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Another UNION ALL query
Hi,
while I can not help you with your direct question, I don't know of a
way to order randomly and select
