On Sun, May 24, 2009 at 02:28:36PM +0200, Lukas Haase wrote: > > SELECT topic_fulltext.topicID > FROM fulltext > JOIN topic_fulltext ON topic_fulltext.fulltextID = fulltext.fulltextID > WHERE (word LIKE 'Word1%') AND (word LIKE 'Word2%');
Obviously this must be empty because a string can't start with "Word1" and start with "Word2" at the same time. Maybe you should try % on both ends of the search string. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users