Hi,
> for mysql < 3.23 you can do something like this.
>
> select ID, ID*0+rand() as rand from partner order by rand limit 1
Thanks a million for the speedy response! It works like a charm!
I don't quite understand how it works though... Could anyone explain? I
really don't like knowing something without knowing how it works.
Best wishes,
--
.-. Chris Boot
/v\ [EMAIL PROTECTED]
// \\
/( )\ L I N U X
^^-^^ >Phear the Penguin<
---------------------------------------------------------------------
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
