Active
Project:
Keyword Autocomplete
Version:
6.x-1.0-beta1
Component:
Documentation
Priority:
Normal
Category:
Task
Assigned:
Unassigned
Reporter:
Created:
13 Jan 2010 at 09:11 UTC
Updated:
13 Jan 2010 at 09:11 UTC
For those interested you can use the following SQL snippet to prepopulate the autocomplete keywords
insert into keyword_autocomplete_keywords(search_keywords, search_count, sources, last_search)
SELECT distinct word, 0, 'b:0;', 1263372541
FROM search_index s
where type = 'node'
and score > 15
and length(word) > 3
and word not in (select search_keywords from keyword_autocomplete_keywords);