Keyword Index
hd_keywords {keyword index}
db eval {
UPDATE keyword SET indexKw=0
WHERE kw GLOB '*s' AND indexKw
AND EXISTS(SELECT 1 FROM keyword AS x
WHERE x.kw = substr(keyword.kw,1,length(keyword.kw)-1));
}
db eval {
SELECT kw, fragment FROM keyword
WHERE indexKw
ORDER BY ltrim(kw,'"''-.') COLLATE nocase
} {
hd_puts "- $kw
\n"
}