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 that I'd like to find: > > A (B | C | D ) D ( A | D ) B B
First guess would be to use GLOB: http://www.sqlite.org/lang_corefunc.html#glob Either as an infix operator, or as a function: http://www.sqlite.org/lang_corefunc.html#glob I cannot find a page which gives SQLite examples using GLOB, but this page http://en.wikipedia.org/wiki/Glob_(programming) gives examples showing the use of square brackets, which appears to be what you want. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users