I have a table that has a column that will contain a comma separated list of keywords associated with each record.

In my application a user has a free text field to enter search terms into that I want to match against the comma separated list in the database. How would you go about doing this? Simple query or implement a FULLTEXT index? Just interested to see what people think would be the best method. Is hold keywords in a comma separated list even the best way of doing this?

Advice appreciated

DJ