Hi,
I'm sure this has been covered before, so I'm sorry for repeating the
question. A search of the list archives yielded nothing.
What I need to do is grab one random row from a table. What I would do in
MySQL 3.23 is:
SELECT * FROM fid_links WHERE featured='yes' ORDER BY RAND() LIMIT 1
How can I do this 3.22? Upgrading to 3.23 is not an option at the moment.
Thanks in advance,
--
.-. 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
