Re: SELECT... ORDER BY RAND() LIMIT x FAILS

2001-03-26 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > >Description: > The documentation says that I can do: > select * from table order by rand() limit 10 > as an example, however it fails and there is no error message. > I *can* do: > select * from table order by rand() > which works fine. It just seems that addin

SELECT... ORDER BY RAND() LIMIT x FAILS

2001-03-25 Thread shawn
>Description: The documentation says that I can do: select * from table order by rand() limit 10 as an example, however it fails and there is no error message. I *can* do: select * from table order by rand() which works fine. It just seems that adding the limit clause causes something to break. >