On 11/29/04 12:27 PM, "mos" <[EMAIL PROTECTED]> wrote: > Mike, > Your solution is way too complicated (it makes my head hurt).<g> > Try this: > > set @n=0; > update tmp set rnd = @n := @n + 1 order by RAND() > > Mike
I'll give this a shot. Follow-up question: I've had a lot of trouble with RAND() on my MySQL 3 box not being all that random. This time I'm using 4.0.17-log. Is it going to be any better? ~ Mike ----- Mike Zornek Web Designer, Media Developer, Programmer and Geek Personal site: <http://MikeZornek.com> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
