Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

"No such function: REGEXP" in sqlite3 on iOS

Is it possible to rebuild libsqlite3.dylib with the regexp function added? Or use create_sqlite_function to do it?

like image 331
nimisis Avatar asked Nov 05 '22 05:11

nimisis


1 Answers

As the SQLite documentation says:

If a application-defined SQL function named "regexp" is added at run-time, that function will be called in order to implement the REGEXP operator.

so you should be able to use create_sqlite_function like you already suggested yourself.

like image 169
milgner Avatar answered Nov 09 '22 13:11

milgner



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!