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 ";
-
how many username do you want from a single select?ariefbayu– ariefbayu2012-11-19 04:44:43 +00:00Commented Nov 19, 2012 at 4:44
-
You want one random user name for each type?Ja͢ck– Ja͢ck2012-11-19 04:46:38 +00:00Commented Nov 19, 2012 at 4:46
-
All usernames present in users table. @ariefbayuAvin Varghese– Avin Varghese2012-11-19 04:47:21 +00:00Commented Nov 19, 2012 at 4:47
-
Random user name available in users table for each type. @JackAvin Varghese– Avin Varghese2012-11-19 04:49:06 +00:00Commented Nov 19, 2012 at 4:49
-
let me wrap: you want to show ALL type with only one random username for each type?ariefbayu– ariefbayu2012-11-19 04:49:51 +00:00Commented Nov 19, 2012 at 4:49
|
Show 1 more comment
3 Answers
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()
2 Comments
Avin Varghese
Want order by mod_type Desc as it.@ariefbayu
Avin Varghese
Thank You ariefbayu for your effort. @ariefbayu
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();
?
1 Comment
WatsMyName
@AvinVarghese, it will obviously fetch all mod types as you dont have any condition to filter out mod types in your query. Try reversing the order by part to,
order by mod_type DESC, rand() 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 ";
2 Comments
Avin Varghese
Want order by mod_type Desc as it.@akhilraj-n-s
Avin Varghese
Thank You Akhilraj for your effort. @Akhilraj N S