I see from the sqlite documentation you can index on a regex , is this possible in Xojo’s sqlite3 wrapper
SELECT * FROM foobar
WHERE pattern
REGEXP ‘foo.*’
etc
I see from the sqlite documentation you can index on a regex , is this possible in Xojo’s sqlite3 wrapper
SELECT * FROM foobar
WHERE pattern
REGEXP ‘foo.*’
etc
probably not
from https://www.sqlite.org/lang_expr.html
pretty sure xojo does not add a user written regexp function to the build of sqlite
EDIT : OH But Thomas T did have a means to add user written C functions to the default sqlite from xojo
let me find it
EDIT : this - http://blog.tempel.org/2015/09/xojosqliteextensions.html
dont think it adds a regexp though