Date: 12/18/05 (MySQL Communtiy)    Keywords: database

I have a database table with 4 keyword fields. I guess they like to store up to 4 keywords against each entry. Unfortunately this makes processing quite difficult, as I'm constantly having to search each field (key1, key2, key3, key4).

Is there an easy way to merge these into a big conglomerate sort of list that would be easier to manipulate?

Source: http://www.livejournal.com/community/mysql/78275.html