subject:"\[sqlite\] Finding similar strings"

Re: [sqlite] Finding similar strings

2009-01-08 Thread htizo

Michael Schlenker-4 wrote: > > htizo schrieb: >> G'day, >> Using sqlitev2.8.17 in php5 is there a way to look up a table for similar >> strings (case insensitive)? >> i.e. If I have the string "BLADEcatcher" >> I want to find "blade_catcher" or "bladecatcher1" or even "bladecatcha" >> so say

Re: [sqlite] Finding similar strings

2009-01-08 Thread Michael Schlenker

htizo schrieb: > G'day, > Using sqlitev2.8.17 in php5 is there a way to look up a table for similar > strings (case insensitive)? > i.e. If I have the string "BLADEcatcher" > I want to find "blade_catcher" or "bladecatcher1" or even "bladecatcha" > so say 60% - 70% of characters the same. sqlite

[sqlite] Finding similar strings

2009-01-08 Thread htizo

G'day, Using sqlitev2.8.17 in php5 is there a way to look up a table for similar strings (case insensitive)? i.e. If I have the string "BLADEcatcher" I want to find "blade_catcher" or "bladecatcher1" or even "bladecatcha" so say 60% - 70% of characters the same. I hope I've explained that