in reply to Random Picks
That is, the ordering by RAND is the trick. I forget which version of MySQL introduces it, but if you don't have it, the other suggestions presented are a bit more portable.SELECT ssn FROM ssn_table ORDER BY RAND LIMIT 3
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: Random Picks
by tune (Curate) on May 10, 2001 at 01:52 UTC |