Hello

I am developing a web application that uses full text searching quite
extensively. This is ideal where I am searching a large number of
large varchar fields for a set of key words.

My problem is that each user on the site has a number of keywords in
the database (approx 200000 users) and when I add a new item with the
large varchar field I need to match all users who's keywords are found
within the varchar text.

I have not yet created the keyword section in the database so could
use either a keyword table with a record for each keyword such as

UserID INT
KeyWord VARCHAR(30)

or a single varchar field for each user that has a list of keywords.

I can think of some horrible solutions to this problem but figure
there must be something better.

Any ideas would be greatly appreciated.

Regards
Chris Chandler