selecting randon records with a select statement....
Moderator: General Moderators
-
mccommunity
- Forum Commoner
- Posts: 62
- Joined: Mon Oct 07, 2002 8:55 am
selecting randon records with a select statement....
selecting randon records.... is there a way to do a select statement and select only random items so instead of select * from table limit 10 you could do select random from table limit 10 ? Any help is appreciated. Thanks.
Code: Select all
SELECT * FROM `table` ORDER BY RAND() LIMIT 10