[RESOLVED] MySQL: GROUP BY substring in column?

[ohnos]

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:

TOPIC 	         	SUBJECT
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

So when output it would be like:
Birth Defects

• Abnormalities

Pregnancy and Reproduction

• Abdominal Pregnancy
• Abnormalities