MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: challenging problem -spliting different values within one field
Posted by: Rick James
Date: April 05, 2014 04:27PM

> split the data in column

Not a good design. Instead, have another table for that many-to-many mapping.

After that redesign, the query becomes a fairly straighforward 3-table JOIN with an ORDER BY `depth`.

Consider also using GROUP_CONCAT().

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
challenging problem -spliting different values within one field
Ali Hesean
April 01, 2014 08:07PM
Re: challenging problem -spliting different values within one field
Rick James
April 05, 2014 04:27PM
Re: challenging problem -spliting different values within one field
Phillip Ward
April 07, 2014 05:59AM


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.