[PHP] condensing a list from MySQL

Hi all, not sure where to start with this. I have a keywords field in a mysql database - allows up to 100 characters of words seperated by spaces. at a late stage in the development process the client would now like a summary list of keywords that they've entered. I guess what I need to do is

RE: [PHP] condensing a list from MySQL

I have a keywords field in a mysql database - allows up to 100 characters of words seperated by spaces. at a late stage in the development process the client would now like a summary list of keywords that they've entered. I guess what I need to do is open each keyword field, extract the

Re: [PHP] condensing a list from MySQL

How about just fixing this so it'll be easier in the future? You should have a separate table where each keyword is in it's own row, with or without duplicates (depends if you want a count of how often the keyword is used), and an ID relating back to the article or whatever you have. I