max = select max(field) from table
select * from table WHERE field>= ${rand(1, max)} ORDER BY field ASC
LIMIT 1
OR
select * from table ORDER BY (field>= ${rand(1, max)}) DESC, field
ASC LIMIT 1
If you're use case is more demanding/complex than that here's a
behavior which does the above using
On Jan 6, 9:28 pm, Alex Ciobanu wrote:
> On 1/6/2011 9:26 PM, Nicolas400 wrote:
>
> > Hi, I want a function that return me a Random Article from my Model.
>
> > I guess all I need is the Find Method, but how do I know how this
> > random number will match an existing ID ??
>
> > I'm really stuck
On 1/6/2011 9:26 PM, Nicolas400 wrote:
Hi, I want a function that return me a Random Article from my Model.
I guess all I need is the Find Method, but how do I know how this
random number will match an existing ID ??
I'm really stuck.
because if I had 3 articles (1,2,3) i want to get a random
Hi, I want a function that return me a Random Article from my Model.
I guess all I need is the Find Method, but how do I know how this
random number will match an existing ID ??
I'm really stuck.
because if I had 3 articles (1,2,3) i want to get a random Id within
those numbers, but if I have 10
