regular expressions in SQLite

[danielrr]

Hi all,

I submitted this very question to the newbies board, but maybe this is the right place to do it. My apologies for the crossposting.

I think in order to be able to make queries on a SQLite database using regular expressions you need a function called regexp; and in order to use this function you need to compile a dynamic library extension. Is this right? If it is, How can you compile such a dynamic library extension to a SQLite database in Livecode? And if not, Which is the right way?

best,

Daniel

[MaxV]

SQLite already supports the REGEXP operator:

Code: Select all

SELECT * FROM mytable WHERE myColumn REGEXP <regex>