Search Engine

Each URL has many keywords. A keyword could be related to more than one URL. I want to run a search that returns urls given a list of keywords to search on.

• = pri key table Keyword(*ID, Keyword) table URL(*ID, URL) table URL_Keyword(*ID, fk_Keyword, fk_URL)

URL 1----M URL_Keyword M-----1 Keyword

search query:
SELECT URL.URL, Count([keyword].[id]) AS Hits FROM URL INNER JOIN (Keyword INNER JOIN URL_Keyword ON Keyword.ID = URL_Keyword.fk_Keyword) ON URL.ID = URL_Keyword.fk_URL WHERE Keyword.Keyword= [Search1] or keyword = [Search2] or ..........etc GROUP BY url.url
ORDER BY Count([keyword].[id]) DESC;

Have i got the right idea? or is there a more efficient way to do this?

I could add a description field to url then use KeyWordInContext (finding keywords delim by spaces) to an entry to Keyword (I should not use 'index' It could confuse).