Or to more directly answer the question... select * from phone where number like '%56%'; Michael D. Black Senior Scientist Northrop Grumman Mission Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of Simon Slavin Sent: Wed 5/26/2010 12:25 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] FTS1 or FTS2 On 26 May 2010, at 6:24pm, Sam Carleton wrote: > 212-456-7890 > 212-789-1234 > 212-564-9875 > 212-357-8452 > 212-285-6100 > 560-851-5522 > > If searching for a number with '56', I want to get back: 212-4*56*-7890, > 212-*56*4-9875, and *56*0-851-5522, NOT 212-28*5-6*100. Is FTS the right > answer or is there a quicker faster way? You don't need FTS3. See LIKE and GLOB in <http://www.sqlite.org/lang_expr.html> Simon. _______________________________________________ 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