Re: [sqlite] regular expressions

>is anybody aware of a possibility to do s.th. like >select * from table where field like '[A|a]%' Unless non-standard compile option and provided you don't issue PRAGMA case_sensitive_like = 1; LIKE is case-insensitive, so LIKE 'A%' is the same as LIKE 'a%' SQLite offers another filtering

[sqlite] regular expressions

Hi, is anybody aware of a possibility to do s.th. like select * from table where field like '[A|a]%' Thanks Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Regular Expressions and sqlite3_create_function

On Mar 20, 2008, at 10:38 PM, Jason Tudor wrote: > I am trying to enable the REGEXP operator. I have read on the > forums that > you must use the sqlite3_create_function. I would like to use the > boost > regular expressions library under the hood. Question is, does > anyone have > an ex

Re: [sqlite] Regular Expressions and sqlite3_create_function

Jason Tudor wrote: > I am trying to enable the REGEXP operator. I have read on the forums that > you must use the sqlite3_create_function. I would like to use the boost > regular expressions library under the hood. Question is, does anyone have > an example using this function (sqlite3_create_fu

[sqlite] Regular Expressions and sqlite3_create_function

I am trying to enable the REGEXP operator. I have read on the forums that you must use the sqlite3_create_function. I would like to use the boost regular expressions library under the hood. Question is, does anyone have an example using this function (sqlite3_create_function) to override regexp(