[RESOLVED] MySQL: GROUP BY substring in column?
Is there a way to do this?
Each "topic" may have multiple "subjects", I'd like to group by the subjects
The db table is like:
So when output it would be like:
Abdominal Pain Digestive System Topics|Symptoms
Abdominal Pregnancy Female Reproductive System|Pregnancy and Reproduction
Abnormalities Birth Defects|Pregnancy and Reproduction
ABO Blood Groups Blood, Heart and Circulation
Pregnancy and Reproduction
- Abdominal Pregnancy