Hello!

Okay, here's my problem. I have lengthy, say, articles and they have one, two, or more authors. If I'm keeping everything in a mySQL db and want to be able to search by author, how would you recommend I go about this? For example:

author = ("Owen", "John");

another article:

author = ("Owen");

I want to still be able to search for articles by Owen or by John. I though about doing a set, but there's about 500 different "authors" so that wouldn't really work

Anyone have any ideas. I'm guessing there's a datatype for something like this, though I couldn't find it on the mySQL reference website. (I really need to buy a book.)

Thanks!
Owen