Re: [sqlite] regular expression search

2009-10-15 Thread Clark Christensen
[AD]BB') > 0; Sorry, it's untested, off the top of my head. -Clark - Original Message From: "Farkas, Illes" <f...@elte.hu> To: sqlite-users@sqlite.org Sent: Thu, October 15, 2009 2:24:16 PM Subject: [sqlite] regular expression search Hi, I have strings in a dat

Re: [sqlite] regular expression search

2009-10-15 Thread John Crenshaw
...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, October 15, 2009 6:00 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] regular expression search On 15 Oct 2009, at 10:24pm, Farkas, Illes wrote: > I have strings in a database and I would l

Re: [sqlite] regular expression search

2009-10-15 Thread Simon Slavin
On 15 Oct 2009, at 10:24pm, Farkas, Illes wrote: > I have strings in a database and I would like to find all of them > matching a pattern that is 5-10 characters long. In each position of > the pattern up to three different characters may be allowed. This > would be a typical regular expression

[sqlite] regular expression search

2009-10-15 Thread Farkas, Illes
Hi, I have strings in a database and I would like to find all of them matching a pattern that is 5-10 characters long. In each position of the pattern up to three different characters may be allowed. This would be a typical regular expression that I'd like to find: A (B | C | D ) D ( A | D ) B B