Re: rand()

[mos]

At 11:25 AM 7/7/2006, you wrote:
I think you meant ORDER BY `registers`..

He may have meant that but then you lose the randomness.
I think it has to be done in 2 steps. I don't see any way of doing it 
without creating a temporary table.

The SQL might look something like this:

drop temporary table if exists tmpreg;
create temporary table tmpreg select registers from tablex order by rand() 
limit 10;
select * from temporary tmpreg order by registers;

Mike



Jay Blanchard пишет:
[snip]
I´ve got a page where a ought to get 20 registers in ramdom order but i 
want to display it in an alphabetical order.
Someone knows if there is a way to get that 20 random registers in 
alphabetical order?
[/snip]
SORT BY `registers`

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]