SQL random selection!?

[unisabilly]

Hi there ~
is that possible to select random rows with SQL !?
let say if i want to select name of three people from NY, how can i do that with SQL, ie. not with php !!

[Wynder]

SELECT firstName, LastName
FROM Users
WHERE state = 'NY'
ORDER BY RAND() LIMIT 3;

[unisabilly]

Wynder wrote:

SELECT firstName, LastName
FROM Users
WHERE state = 'NY'
ORDER BY RAND() LIMIT 3;

Thanx very much ~
it works perfectly ~ 🙂