On 07/15/2011 03:28 AM, Alexey Pechnikov wrote: > 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?..
I think you could just have the tokenizer return "dbms" whenever it sees "sqlite" in the input. Both documents and tokens that appear in queries are transformed by tokenizers. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users