Randomly sort a query?

[Primogenitor]

Is there a way to randomize the order of rows in an SQL query result using SQL? I know I could load all the rows from the result back into the module, store them as locals, and then randomly pick one once I know how many there are. But it would be neater if I could have the SQL randomize the list and then I can just take the first result and ignore the rest.

[NoMercy]

Easy :)

[Primogenitor]

For future reference, while RAND() works in MySQL, if your using SQLite you need random() instead. Otherwise this does exactly as it says on the tin.

One other question, anyone got any suggestions for a weighted random? I could use multiple entires, but that gets messy for updates. Any better suggestions?

[NoMercy]

Bit harder:

[Xildjian]

I'm using the access ODBC db, and this doesn't seem to work for me. What I'm trying to do is this.

I have a table of gems with fields: tag, gp, and name
What I would like to do is grab the tag, from a random row where gp<=somevalue.

I tried something like:

[Primogenitor]

Try these:
Rand()
Random()
random()
rand()
RANDOM()
RAND()
Dont know which one works, but one of them probably will

[Xildjian]

Thanks, I did try RANDOM() and RAND() before your post. I then switch over to mySQL and it appears to be working.

Thanks!
_________________
Member Shadow of Iniquity development team