Quoting Richard Reina <[EMAIL PROTECTED]>:
> I am trying to get this query to randomly pick a
> record from a table (trans) but it's not working:
>
> SELECT ID FROM trans ORDER BY RAND() LIMIT 1;
>
> Can anyone let me know what I'm doing wrong and/or how
> to fix it.
>
> Thanks,
>
> Richard
>
Wha
I am trying to get this query to randomly pick a
record from a table (trans) but it's not working:
SELECT ID FROM trans ORDER BY RAND() LIMIT 1;
Can anyone let me know what I'm doing wrong and/or how
to fix it.
Thanks,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mys