I clearly am not in the right mindset to be answering list emails. Please ignore my response (it's too late now)--back to my stressful deadline.
Strange that it's implemented for prefix and not postfix? Wes On Wed, Aug 5, 2009 at 8:58 PM, Lukas Haase<lukasha...@gmx.at> wrote: > Wes Freeman schrieb: >> Why not LIKE '%otor'? > > SELECT topic_title FROM topics > WHERE topic LIKE '%otor%' > ORDER BY topic_title ASC; > > This is very, very slow, especially on my > 100 MB database. "Realtime" > search in the GUI is a requirement. This is exactly the reason why I > want to use FTS instead of LIKE... > > Regards, > Luke > >> >> Wes >> >> On Wed, Aug 5, 2009 at 7:47 PM, Lukas Haase<lukasha...@gmx.at> wrote: >>> Hi, >>> >>> It's me again, sorry. The next big problem concerning FTS. I have the >>> requirement to do postfix searches, like: >>> >>> SELECT topic_title FROM topics >>> WHERE topic MATCH '*otor' >>> ORDER BY topic_title ASC; >>> >>> should find Motor, motor, Monotor etc. But this does not seem to work. >>> Is there any chance to get this working? >>> >>> Best regards, >>> Luke >>> >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
