Re: select random row from a group

Thomas，

The following is an approach to select randomly one record from the
whole lot. Perhaps you can get it to do what you want. But I would
recommend, either splitting the different in different tables (at least
temp tables for this queries).

Steps:
1) Add and AUTO_INCREMENT column to the table (eg. recordID type=int)
2) Try this select statement:
SELECT *
FROM randtest
WHERE recordID = ( FLOOR( RAND() * MAX( recordID ) + 1 ) )

Points to note:
-The RAND result is multiplied by the max recordID (you might
find counting the records easier, as this will error, if the index has
missing records)
- I have added the +1, so that the result of the Floor never
returns 0, you can use CEIL if you wish it is the same difference, just
remove the +1

Hope this helps.

Corey Scott
/* ================================================================ *\
| "My life is spent in one long effort to escape from the
|
| common places of existence. These little problems
help |
} me to do so." -Sherlock
Holmes |
\* ================================================================ */

---
[This E-mail scanned for viruses by Declude antiVirus]