Getting random values ​​from mysql

Question

How to get 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

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(); 

?

Answer 2

You can use ORDER BY RAND() to do this:

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

Answer 3

Mysql supports the RAND() function

  select a.mod_name, u.user_name, a.id from type a, users u where a.id=u.mod_type order by RAND(),mod_type Desc ";