Why not LIKE '%otor'? 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