Rand() Question

[GundamSV7]

Hey, I currently have a mysql database with a world table. There's 3 columns, x, y, and type. I want to randomly select a row where type=2 and get the x and y values for that row. Any idea how to go about doing this?

[eli03]

try this
SELECT * FROM tablename where type='2' ORDER BY RAND() LIMIT 1

[bodzan]

Let's say you have a table with 1000 records. You need the id field or something similar with unique values for each row.

In that case you could do this:

rand(0,1000);

Then with this number you check if the row with that id has the type=2, if that's the case, you can read x and y from it, otherwise go with it again...