List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 5 1999 8:42pm
Subject:Re: random row
View as plain text  
At 1:35 PM -0500 9/5/99, Faisal Nasim wrote:
>Can I fetch a random row from hundreds of rows returned by a
>certain criteria?

MySQL 3.23.3 will (I believe) has an ORDER BY RAND(), which you can
combine with LIMIT 1 to achieve the desired effect.

Paul DuBois, paul@stripped
Northern League Chronicles:
random rowFaisal Nasim5 Sep
  • Re: random rowPaul DuBois6 Sep