Mining the search engine

From Drafts

Revision as of 09:48, 3 May 2006 by NicolasM (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

Listing the keywords by weight

SELECT engine.key_id, SUM( engine.weight ) AS wa, keywords.keyword
FROM ENGINE , keywords
WHERE keywords.key_id = engine.key_id
AND LENGTH( keywords.keyword ) >2
GROUP BY key_id
ORDER BY wa DESC

Viewing the distribution of the keywords by folders, by sites, by pages

Retrieved from "http://interne.constantvzw.org/index.php?title=Mining_the_search_engine&oldid=2003"

Data mining