MySQL table structure question

[LDusan]

Hi all

I am about to make one MySQL table called Catalogue, which will be catalogue for one bookshop. My dilemma is this:

Considering some books have multiple authors, would it be better to create multiple fields in one row(Author1, Author2) or put all authors for the particular book in one field and let's say separate them with comma. I am asking this so I won't need to restructure my whole database when implementing search engine or something advanced. So the question is, what is more convenient?

[Weedpacket]

Have a second table for authors. Have an ID column in both tables. Have a third table that lists bookID/authorID pairs (obviously, when author 17 wrote book 42 there'd be a (42,17) pair in that table).

The phrase to search for more about this concept (which is a fundamental aspect of relational database design) is "database normalisation".