Difference between revisions of "Mining the search engine"
From Drafts
| Line 11: | Line 11: | ||
* Viewing the distribution of the keywords by folders, by sites, by pages | * Viewing the distribution of the keywords by folders, by sites, by pages | ||
| + | [[Category:Data mining]] | ||
Latest revision as of 09:48, 3 May 2006
- 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
