Hey,

I have a single table with 1 column and close to 4000 record ids. The rows are just numbers like 481, 24 etc.

Now certain words can be grouped, like may be 24 and 481 are similar. So I have another table with 1 column named "similarids". There I have ids like this 1,8,9 to mean the items are similar.

Now, what i want is the user views say item 24. Then ids that are similar to it be listed.

There is no need to have another table to link to the main table cos the similarity is so random, more like similar words. But if it is better, give me a reason if you have.