List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:February 5 2000 12:21am
Subject:Re: LIMIT RND * 10
View as plain text  
At 9:09 PM -0300 2000-02-04, Ernesto wrote:
>I can't do this:
>
>SELECT * FROM mytable LIMIT (RND * 10),1
>
>why? Isn't that a legal sentence?


No.

LIMIT requires constants, not expressions.

-- 
Paul DuBois, paul@stripped
Thread
LIMIT RND * 10Ernesto5 Feb
  • Re: LIMIT RND * 10Paul DuBois5 Feb
  • Re: LIMIT RND * 10sinisa@mysql.com5 Feb