Find random, THEN order by date?

[adelante]

Doing a blog thing, but it is only updated once every month with about 10 new records, so I was making a little script to select some random records, but it doesn't seem to be possible to select 3 random records first, and THEN order them by date. Or is it??

Here is what I got right now:

SELECT date,text FROM blog ORDER BY RAND() LIMIT 3

I have tried to place ",date" different places but it doesn't work.

Any ideas would help
Thanks!!

 

[KarveR]

You could try:

SELECT rand() as rand, date, text
FROM blog
ORDER BY rand
LIMIT 3;

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[KarveR]

whoops, ORDER BY rand,date asc limit 3;

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.