hello
i doesn't want to get the same results each time i query mysql db.i want the results to be shuffled each time i query .please tell some time saving technique for shuffling result set from mysql..
ankit1122 -3 Junior Poster in Training
pritaeas 2,211 ¯\_(ツ)_/¯ Moderator Featured Poster
Simplest, but not very fast:
SELECT * FROM `table` ORDER BY RAND()
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.