I would recommend going with a table of keywords like
you said, you may want ot structure like this:
[ words_id | article_id | word ]
You can tie the "article id" to the other tables
getting an efficient multiple word search working is a
bit of a task.
This is very helpful:
http://www.database
Hi Guys,
I need to create a search engine that catalogs data from about 4 separate tables,
and then of course is searchable from use input. I'm having a brain fart on how I
should go about doing this. This is what I think I should do so far tell me if I'm
right or at least going in the r