Jule <[EMAIL PROTECTED]> writes: > Hey guys, > i have a db and a table with id and questions > > now i want these questions to be listed in a random order, is there a way to > format my SQL query or do i need some PHP work to?
SELECT foo FROM bar ORDER BY rand(); Just to pick one: SELECT foo FROM bar ORDER BY rand() LIMIT 1; -- Per Andreas Buer --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
