CODEWITHSUNDEEP
phpmysql
Avin Varghese
Avin Varghese

Reputation: 4370

Getting Random values from Mysql

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 ";

Upvotes: 4

Views: 91

Answers (3)

WatsMyName
WatsMyName

Reputation: 4478

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

?

Upvotes: 3

Akhilraj N S
Akhilraj N S

Reputation: 9457

Mysql supports 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 ";

Upvotes: 2

ariefbayu
ariefbayu

Reputation: 21979

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

Upvotes: 4

Related Questions