Generate A Mysql Results With One Query Order By Random

i will show you in this simple query example how to query the results by random order [932], Last Updated: Tue Feb 07, 2023

mel

Mon Jul 18, 2011

1 Comments

523 Visits

hi, ok, today i was working on a script using php and mysql, i wanted to query my database and i wanted the order to be listed in a random format. so this is what i did, in this query i will show you.

$Query = "SELECT * FROM mytable WHERE id=23 ORDER BY RAND()";

as you can see, the query will be sorted randomly

Jonathon

Wed Jul 27, 2011

Hello Mel, Hard to tell if you're asking or saying it's correct: I doubt it would work. I don't use php, but the sql statement still needs to be processed by mysql. I think this might work if MySQL supports a random function: Select *, RAND() as X from mytable WHERE id=23 ORDER BY X And even with this you might have to use a prequery to generate the random numbers and then order by the named field of the random numbers in a second query; i.e., the sql engine might want to optimize the select with the order by. Either way...

https://www.wallpaperama.com/forums/_wxxpre.html

Mysql Use Concat To Combine Two Or More Field In A Table

Generate A Mysql Results With One Query Order By Random

Related Pages