On 24/2/2011 1:49 AM, Simon Slavin wrote: > I would not try to make each individual word of a name a row in a table. I > think 'LIKE' is designed almost exactly for your problem: > > <http://www.sqlite.org/lang_expr.html#like> > > This means you can search on any component of the name. for instance, > > SELECT id,name FROM contacts WHERE name LIKE '%ell%' > > will find all the 'Kelly' entries and also all the 'Ella' entries. Similarly > > > SELECT id,name FROM contacts WHERE name LIKE '%Simon Kelly%' > > Would return 'Simon Kelly Smith' and 'Simon Kelly Grant' and 'Eric Simon > Kelly' and even 'Simon Kellyson' and 'Jossimon Kellysen'.
Hi Simon and Simon, Thank you for your suggestions - I tried the approach using LIKE and it seemed quite slow (this was on Windows CE).. FTS3/4 seem good to explore. Cheers, Mohit. 24/2/2011 | 11:23 PM. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users