I want to add the table CREATE TABLE ext_fts_synonyms(word text not null unique, synonym text not null); insert into ext_fts_synonyms('sqlite','sqlite dbms');
And replace in tokenizer the term 'sqlite' to 2 terms 'sqlite' and 'dbms' for search by queries like to > select text from fts where fts match 'dbms educate'; 'SQLite may be useful for education' But how to return from tokenizer 2 terms or more instead of single term?.. Note: Snowball stemmer and stopwords table I did add and can do: > select text from fts where fts match 'sqlite educate' SQLite may be useful for education -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users