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
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 - Views of a Coder: Xojo SQLite databases: Enabling ICU for full Unicode support and adding custom functions
dont think it adds a regexp though