MS Full text search adding association

I have a DB with company names and description. i have a full text search on name,d开发者_如何学Pythonescription.

The questions is there any way i can associate words with other words. Let me explain

i have records like

Name Whoo Whaa Description Best chinese in the world

Name Steak Range Description Best hamburger in world

What i would like is if i search say "food" i must get these records so i need to somehow link hamburger and chinese to food. Is this possible.

you need tags, just add a string column to your table called Tag and store food in there ( or even multiple tags comma separated). Then extend the FT index to also include the new column.