Xav wrote:
> I'd need a random function to choose a line sample of a table. In
> searching into the mailing I found that "Eric Jain"
> unsucessfuly asked
> such a question on August 2002. Is there something new since ?
What exactly do you want to accomplish?
Is it
(1) obtain a random value and use that in the where clause of a query:
(SELECT * FROM TAB WHERE KEY = :random)
or
(2) do a "special" query and get as a result a collection of randomly
selected rows of the table?
IMHO in both cases it is the job of the application. Nearly all application
development languages provide means to obtain (pseudo) random numbers. Use them
in the obvious way in case (1).
In case (2) use random numbers to control a series of FETCHes to keep only a
few randomly chosen rows.
HTH
Christian
--
#include <std_disclaimer.h>
/* The opinions stated above are my own and not
necessarily those of my employer. */
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
