Getting Random values from Mysql

Question

How to fetch RANDOM User_names.

SELECT a.mod_name, u.user_name, a.id from type a, users u 
WHERE a.id=u.mod_type
ORDER BY mod_type Desc ";

Answer 1

You can use ORDER BY RAND() for that:

SELECT a.mod_name, u.user_name, a.id
FROM type a, users u
WHERE a.id=u.mod_type
ORDER BY RAND()

Answer 2

What about

EDIT:

select a.mod_name, u.user_name, a.id from type a, users u where a.id=u.mod_type 
order by mod_type DESC, rand();

?