CAVALO SCHMIDT <[EMAIL PROTECTED]> writes: > > Salutations, > > Is it possible to do a simple wildcard/regexp-type search in sqlite > databases, but with indexing? For example, if I want to search for the > string "aCa", we would do only one SELECT * FROM a WHERE a = "aCa", > and it would interpret "C" as any letter in "bdgjklmnpqrstv". So, one > SELECT would be equivalent to several ones with "C" replaced by any of > those letters: > SELECT * FROM a WHERE a = "aba" > SELECT * FROM a WHERE a = "ada" > SELECT * FROM a WHERE a = "aga" > SELECT * FROM a WHERE a = "aja" > ... > Or, for example, if I want to call SELECT * FROM a WHERE a = "string", > have it search for "string", " string", "string " and " string ". > I think that, in an indexed database, making several SELECT's like > that would be faster than using LIKE or REGEXP. > Of course, we could implement the generation of all the SELECT's in C > and/or Perl, for example, but it would be extremely more practical if > we could call SELECT only once and have it consider "C" as any > consonant, and it would be equivalent to calling SELECT several times. > > Thank you in advance.
I would appreciate if anyone could give a solution to this problem. How to write a SELECT query that considers the letter "C" as any letter in "bdgjklmnpqrstv"? Or that considers that there may be spaces before and after the word searched? Thank you in advance. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
