If I had a database of musicians and a column for various info, would it be possible to have more than 1 entry for searching purposes? For example, if I had Shania Twain, and a column for music genre, she could be considered country or pop. If my search did select * from Musicians where genre = pop, I would want her to come up, but I would also want here to come up if the genre was country. How would I go about doing that, or would I have to do some scripting to filter the results?

Well, the trick is using more than one table. Have a table with different genres as it's columns and two ID's, one unique id for that specific entry and one ID that matches the artist ID you want to associate with that genre. Now when you insert records into both tables you can simply use a 1 or a zero for each genre in the table, if its a one then their music belongs in that genre if its 0 it's does not.

Ohhh...so in tableMusicians I could have:
pKey = 1
Artist = Shania Twain
Whatever = Crap

Then have tableGenre:
pKey = (some unique number)
ArtistID = 1 (Shania's pKey)
Pop = 1
Country = 1
Death Metal = 0

So I would then search tableGenre for Country = 1, if I wanted that genre?

Exactly, I hoped I was being clear enough. Glad you got it.