include REGEXP function in to SQLite

[anonymous]

documentation on sqlite site said:
The REGEXP operator is a special syntax for the regexp() user function. No regexp() user function is defined by default and so use of the REGEXP operator will normally result in an error message. If an application-defined SQL function named "regexp" is added at run-time, then the "X REGEXP Y" operator will be implemented as a call to "regexp(Y,X)".
so i went ahead and try but (obviously) get :

--> Error:    no such function: REGEXP

so - can regexp be included in you compilation of sqlite x86/x64 dll?

[TicketCleanup]

Automatic ticket cleanup.

[jchd18]

Regexp operator isn't very useful because it is so slow and contrary to LIKE and GLOB, can't benefit from any index. That's why no regexp function comes as standard.

However a simple (non-PCRE) implementation is available in the source tarball of the official website, under directory .\ext\misc\regexp.c which is ready to be compiled into an SQLite extension DLL.

[jchd18]

See ​http://www.autoitscript.com/forum/topic/162819-regex-in-sqlite/#entry1184601