MySQL Forums
Forum List  »  InnoDB

Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
Posted by: Roland Bouman
Date: March 06, 2006 02:45PM

Phil, I'm so glad you finally solved the problem.

I must admit, the student_ethnicity_other stuff is new to me - I never guessed you wanted to involve that too into the sorting calculation.

Anyway, just for the record - where did you get the idea that you had to include the ethnicity_name column in the GROUP BY? I hope I didnt put you on the wrong track... (as far as I can see, I included either group_concat or the alias for the group_concat in the ORDER BY list, never in the GROUP BY list)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2444
March 06, 2006 02:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.