Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Re: Find most common words in database for stop words?

Quote Reply
Re: Find most common words in database for stop words? In reply to
Actually, I think that got me pointed exactly where I needed...

Two simple sql statements will get what I think I want:

select * from Links_Word_Index order by Frequency desc limit 100;
and
select * from Category_Word_Index order by Frequency desc limit 100;

I didn't realize these tables track the Frequency of the word, which I'm assuming is how often it appears in the category and in the title and description (the only two fields I have weighted in the Links table defs).

Now I can pick and choose the words I want to include in stop words. Haven't figured that part yet, but at least now I know how to get the words...

Thanks much.

Jerry


Subject Author Views Date
Thread Find most common words in database for stop words? JerryP 1094 Jun 12, 2000, 2:38 PM
Thread Re: Find most common words in database for stop words?
pugdog 1043 Jun 12, 2000, 6:46 PM
Post Re: Find most common words in database for stop words?
JerryP 1035 Jun 12, 2000, 10:22 PM