Mining the search engine

From Drafts
Revision as of 13:28, 13 January 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