Hi!
On Jul 07, Scott A. Hammond, Sr. wrote:
> I am running MySQL 3.23.54.
>
> Query: SELECT column1, column2, RAND() AS column3 FROM table WHERE column2
> IS NOT NULL ORDER BY column3 LIMIT 10;
>
> I am running this query within a PHP page that uses mysql_connect. More
> then 9 out of 10 times
Since you are ordering by column3, ( in other words sorting your random
mumbers ),
what do you expect?
Scott A. Hammond, Sr. wrote:
I am running MySQL 3.23.54.
Query: SELECT column1, column2, RAND() AS column3 FROM table WHERE column2
IS NOT NULL ORDER BY column3 LIMIT 10;
I am running this que
I am running MySQL 3.23.54.
Query: SELECT column1, column2, RAND() AS column3 FROM table WHERE column2
IS NOT NULL ORDER BY column3 LIMIT 10;
I am running this query within a PHP page that uses mysql_connect. More
then 9 out of 10 times I get the first 10 rows of the database in order,
i.e. 1, 2