AlliedModders - View Single Post

**DarkDeviL** · 03-14-2016 , 05:01 Re: [CS:GO] Get Random Row from Database

Quote:

Originally Posted by Kailo

em, this not sourcemod question, is't SQL. And if use google

http://stackoverflow.com/questions/1...dom-row-in-sql
For MySQL:

Code:

SELECT column FROM table
ORDER BY RAND()
LIMIT 1

Now you're so smart to suggest Google, have you considered using Google yourself, to find out if "ORDER BY RAND()" could be a bad idea?

If you have a large database, such as player tracking (or store) databases, don't use "ORDER BY RAND()".