Hi, I've an actually quite simple problem, so I guess someone might know an answer... I just need a single random result from my query.
With an older MySQL-Version this construction worked fine but with the new one not at all: "SELECT ... ORDER BY RAND() LIMIT 1" So I tried out this one: "SELECT column, ... , RAND() AS random FROM table ORDER BY random" I get different random values, but it does not work in combination with ORDER BY - it's just not sorted. So is there any solution for this?! Thanks in advance, Angela --------------------------------------------------------------------- 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
