I was doing a basic query on my windoze 98 system like so:
Select * from table_name order by RAND() LIMIT 1;
When i tried to port this to a linux box running mysql 3.22.32 it doesn't
seem to work. I thought this was compatible with that version but i guess
not. Can anyone recommend another way of doing this?
I was thinking of doing something like this ::
select column1, column2, floor(count(*) * rand()) as randRecord from
girls g1, girls g2 where g1.randRecord = g2.girlPicId;
but that doesn't seem to work.. and mysql doesn't support subqueries.. :(
any ideas? (without telling me to upgrade because it's not my server)
Thanks in advance!!
Cisk
- http://www.txraves.org/djcisk/
---------------------------------------------------------------------
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
