GROUP_CONCAT question

Dev Shed Forums Sponsor:

February 4th, 2013, 12:11 PM

bayken37

Registered User

Join Date: Jan 2013

Location: Paris, France

Posts: 15

Time spent in forums: 4 h 38 m 36 sec
Reputation Power: 0

GROUP_CONCAT question

I'm wondering how (if possible) to control the order of the values that go into the GROUP_CONCAT output

I would like them to be based on an ID number that I have associated with their names ("p_id" which is different from their "id" number)

When I run the following into MySQL the list seems to be ordered arbitrarily or based on something else

PHP Code:


		
			
 SELECT Year, GROUP_CONCAT(CONCAT((LEFT(FName,1)),"."," ",LName)) AS Player

FROM gg

WHERE lid = 1 

GROUP BY Year

Thanks in advance!

February 4th, 2013, 06:25 PM

r937

SQL Consultant

Join Date: Feb 2003

Location: Toronto Canada

Posts: 26,380

Time spent in forums: 3 Months 1 Week 2 Days 7 h 54 m 8 sec
Reputation Power: 4140

Code:

SELECT Year
     , GROUP_CONCAT(
         CONCAT(LEFT(FName,1),'. ',LName)
         ORDER BY p_id 
                  ) AS Player
  FROM gg
 WHERE lid = 1 
GROUP 
    BY Year

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book

Viewing: Dev Shed Forums > Databases > MySQL Help > GROUP_CONCAT question

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump