Extract multiple values from single field and join
I'm not extremely well versed in MySQL... this may end up being a fundamental or basic in database design and implementation. (by the way I'm using PHP)
I'll give the trimmed down example of what I'm working with: