how can i query related topics?

[ALKateb]

Hello everybody!
as u all see in articles directories, discussions boards or even software websites ..etc
right after u go the article page or the software page it will show u posts related to this post ure in how do they do that exactly?
i was thinking! does it break the string to words then make make a query to select records that have this word in them?

or is it somehow different?

how can i do that
thanks a lot in advance

[penders]

If I was going to do this I would make a query based on tags/keywords assigned to the original article. Searching by tags should be a lot quicker than a general 'word' search and would hope to retrieve more relevant results. Related articles for any particular article could also be cached for a period of time to lessen server load.