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