Parse a database field that is comma delimited and input the results into another table

[penguinspeaks]

Using classic ASP and MySql database.,
I want to parse a field that contains a list of tags, and take those results and input into another table.
So if I had tea,coffee,bread,milk in a field, it would parse that field and give me
tea
coffee
bread
milk

then upload the list into a different table

Once I get the parsed items, I can handle uploading it, I just need help on parsing it, really.

I have searched parsing, but I get confused very easily. I've had a few strokes and my brain doesn't work like it used to.

Any guidance will be appreciated

Thanks,
Penguin
Please keep in mind that I am using classic ASP with MySQL database. Not sure if that information helps or not.