MySql Help - GoFuckYourself.com

seeme · 07-22-2012, 09:34 AM

Ok I have the following tables, what I want to do is select 1 random item from ITEMS for each group in GROUPS. If possible done in 1 query.

ITEMS
ID - NAME - DESCRIPTION - GROUP

GROUPS
ID - TITLE - STATUS

Thanks

Harmon · 07-22-2012, 09:37 AM

I guess your answer lies within gun control in the US. If only there weren't so many gunzzzzzzzzzzzzzzzzzz!

Faggot. Suck a cock.

fris · 07-22-2012, 11:05 AM

Quote:

Originally Posted by XYZTraffic

Ok I have the following tables, what I want to do is select 1 random item from ITEMS for each group in GROUPS. If possible done in 1 query.

ITEMS
ID - NAME - DESCRIPTION - GROUP

GROUPS
ID - TITLE - STATUS

Thanks

i left you a few msgs, you can cancel the thing we talked about.

kazymjir · 07-22-2012, 11:18 AM

Code:

SELECT *
   FROM `items`
   GROUP BY `group`
   ORDER BY RAND();

Selects one random item from each group

seeme · 07-22-2012, 11:53 AM

Quote:

Originally Posted by kazymjir

Code:

SELECT *
   FROM `items`
   GROUP BY `group`
   ORDER BY RAND();

Selects one random item from each group

When I refresh the query I still get the same item from each group... just that the final list of items is ordered randomly.

kazymjir · 07-22-2012, 12:49 PM

Quote:

Originally Posted by XYZTraffic

When I refresh the query I still get the same item from each group... just that the final list of items is ordered randomly.

Ahhhh, true.

Try this:

Code:

SELECT * 
   FROM (SELECT * FROM `items` ORDER BY RAND()) x
   GROUP BY x.group
   ORDER BY RAND();

ShoeBox · 07-22-2012, 02:31 PM

Quote:

Originally Posted by Harmon

I guess your answer lies within gun control in the US. If only there weren't so many gunzzzzzzzzzzzzzzzzzz!

Faggot. Suck a cock.

seeme · 07-22-2012, 03:04 PM

Quote:

Originally Posted by kazymjir

Ahhhh, true.

Try this:

Code:

SELECT * 
   FROM (SELECT * FROM `items` ORDER BY RAND()) x
   GROUP BY x.group
   ORDER BY RAND();

Thanks thats what I needed

adultdomainseller · 07-22-2012, 03:54 PM

Quote:

Originally Posted by Harmon

I guess your answer lies within gun control in the US. If only there weren't so many gunzzzzzzzzzzzzzzzzzz!

Faggot. Suck a cock.

07-22-2012, 09:34 AM	#1
seeme Stephen Industry Role: Join Date: Jun 2011 Location: Europe Posts: 840	MySql Help Ok I have the following tables, what I want to do is select 1 random item from ITEMS for each group in GROUPS. If possible done in 1 query. ITEMS ID - NAME - DESCRIPTION - GROUP GROUPS ID - TITLE - STATUS Thanks

07-22-2012, 09:37 AM	#2
Harmon ( ͡ʘ╭͜ʖ╮͡ʘ) Industry Role: Join Date: Mar 2004 Posts: 20,007	I guess your answer lies within gun control in the US. If only there weren't so many gunzzzzzzzzzzzzzzzzzz! Faggot. Suck a cock. __________________ [email protected]

07-22-2012, 11:18 AM	#4
kazymjir Confirmed User Industry Role: Join Date: Oct 2011 Location: Munich Posts: 411	Code: SELECT * FROM `items` GROUP BY `group` ORDER BY RAND(); Selects one random item from each group __________________ http://kazymjir.com/