Database Search

[OuTCasT]

Hi.

I have a table that has products from different companies in it, they also have described the products in 10 key words.

Now i want to be able to search for those products in the db using keywords that a person will type into a textbox when he searches for the specific product he is looking for.

then it will search through the products and bring out those companies with the same keywords ?

[Delerna]

Are the 10 keywords in the same field or is there a field for each keyword.
or do you have the keywords in their own table (probably the better option)

[OuTCasT]

Are the 10 keywords in the same field or is there a field for each keyword.
or do you have the keywords in their own table (probably the better option)

the keywords are all in there own fields in there own table.....