How to find similar stories based on keyword matching?

[IWannaWin]

I have a table, story_keywords which contain keywords matched up to a specific story with the following columns: id, story_id, keyword_id. Now what I want to do is grab any story that shares at least two keywords with the primary story I'm outputting from the initial loop of getting all stories for today. \[quote\] // get list of keyword_ids for the primary story // get list of all stories, and their keyword_ids, that match when I cycle through primary story keyword_ids\[/quote\]But I'm stuck, I can't think this out logically for some reason. Can someone advise? I'm not sure what other information I can provide to make this more clear. I can get a list of stories that match with 1 keyword from the primary story, but I want it to match at least two keywords in order to output the similar story.