Re: sql question

by "Darrell King" <darrell(at)webctr.com>

 Date:  Tue, 20 Feb 2001 13:41:52 -0500
 To:  <hwg-techniques(at)hwg.org>
 References:  KLAI1
  todo: View Thread, Original
mySQL has this built in as of 3.23.3:

SELECT column FROM table ORDER BY RAND();

----- Original Message -----
From: "Kenny Lai" <klai(at)rs1winc.com>
To: <hwg-techniques(at)hwg.org>
Sent: Tuesday, February 20, 2001 12:37 PM
Subject: sql question


i'm trying to select a random row from a select statement, what is
the best
possible way to do this?

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA