Ideally, you should have an Artist field, and an Album field. This allows much more flexibility, such as the case you are seeing now.
To take it even further, there should be separate "artist" and "album" tables, as there can one artist to many albums (one-to-many relationship). In fact, you could potentially need a many-to-many relationship (more than one artist to an album). Doing this is called database normalisation.
|