January 8, 2009 11:09pm pst

11.28.2008 at 01:24PM PST, ID: 23942979 | Points: 500

	[x] Attachment Details

How to SELECT DISTINCT and have random result GROUPing by

Zones:

KornShell (ksh), MySQL Server

Tags:

SELECT DISTINCT, random

I have a RECORDSET wich gives me as result a list of tag names with a its link text.

I want to have this results with random order BUT I want to exclude from results WHERE link_tag value is redundant, I want unique value on link_tag column.

This recordset works BUT the link_tag value I get is always the same. Maybe because the ORDER BY is after the group by and not viceversa.

How can I do this and get 10 ramdom results from my tag list where link_tag column has unique value

         
             SELECT DISTINCT tags_cat.*, tags_tag.*, rand() as randome
FROM (tags_tag LEFT JOIN tags_cat ON tags_cat.id_tags_cat=tags_tag.idcat_tag)
GROUP BY link_tag
ORDER BY randome desc LIMIT 10

Related Solutions

Keywords: distinct, random, recordset, wich, redund, exclud, random

#	Title
1	Generate a random password
2	how to display 6 distinct random items?
3	How random is random?
4	randomize in recordset
5	Random Not Really Random
6	Random Records

20081119-EE-VQP-46 - Hierarchy / EE_QW_3_20080625

1. ozo 225

1. ozo 84,020
2. Tintin 77,014
3. omarfarid 51,706
4. ghostdog74 19,525
5. sentner 15,500
6. MikeOM_... 12,900
7. Adam314 9,400
8. amit_g 8,236
9. ahoffmann 7,725
10. sunnycoder 7,272
11. gheist 5,614
12. sjm_ee 5,500
13. johnsone 5,300
14. JustUNIX 5,000
15. nognew 2,800
16. marchent 2,600
17. jools 2,560
18. oklit 2,500
19. nixfreak 2,375
20. RSLE 2,100
21. blu 2,000
21. tfewster 2,000
21. murugesa... 2,000
21. awking00 2,000
21. amnonnes 2,000
21. just-Dave 2,000
21. MentorJay 2,000
21. hernst42 2,000
21. Milleniuma... 2,000
21. sdstuber 2,000
21. FishMonger 2,000
21. fridom 2,000