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. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
