SQLCipher Regex Support

[developernotes]

Hi @chitabi

This question has been addressed in the below link. If you have additional follow-up questions, please feel free to post those below:

net.sqlcipher.database.SQLiteException: no such function: REGEXP

Hello @Bharath_Kumar_Bachin - no SQLCipher doesn’t naively support a regex function. Like the upstream SQLite, if you provide your own regexp() function the keyword should work however: 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 …