Aug 5, 2003 #1 Skute Programmer Jul 21, 2003 272 GB Hi, is it possible to create a "random selection of rows" from a table? ie. If a table has 100 rows, can i select a random 25 of those? Thanks.
Hi, is it possible to create a "random selection of rows" from a table? ie. If a table has 100 rows, can i select a random 25 of those? Thanks.
Aug 5, 2003 #2 sleipnir214 Programmer May 6, 2002 15,350 US Sure SELECT * FROM tablename ORDER BY rand() LIMIT 25 Want the best answers? Ask the best questions: http://www.catb.org/~esr/faqs/smart-questions.htmlTANSTAAFL!! Upvote 0 Downvote
Sure SELECT * FROM tablename ORDER BY rand() LIMIT 25 Want the best answers? Ask the best questions: http://www.catb.org/~esr/faqs/smart-questions.htmlTANSTAAFL!!
Aug 5, 2003 Thread starter #3 Skute Programmer Jul 21, 2003 272 GB thats great thanks Upvote 0 Downvote