Hello,

I realized that there could be quite a few values in the searchlog table. For those of you who have a very popular website there can be easily thousands of entries within a month.

To get the latest data (makes the search log more accurate), use the following sql statements:

DELETE FROM idx_searchlog WHERE time < '2003-03-31'
DELETE FROM idx_searchlog WHERE time LIKE '2003-03-31%'

These two statemensts delete all keywords which are older than 2003-04. If you want to get more specific data, just enter a different date (e.g. 2003-04-30 => keywords for the last month).

Please do a backup before you use these statements, caus you might do some keywords analysis in the future!

greets

Joerg