Re: [sqlite] sqite wildcard search with indexing

2008-07-26 Thread CAVALO SCHMIDT
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

[sqlite] sqite wildcard search with indexing

2008-07-21 Thread CAVALO SCHMIDT
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