Queries for tagging system

[Dudsmack]

I am playing around with building a tagging system in PHP. I plan on having a table in my database as follows:

table-name: prefix_tags
structure: id, name

Every article will have a tag field, which will be a comma delimited list of the ids of tags that article will belong to.

Given that I have the list of ids to tags the article belongs to, how can I create a single query to retrieve all the name fields from prefix_tags?

Thanks in advance!