regular expressions in SQLite

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, robinmiller, kevinmiller

Post Reply
danielrr
Posts: 115
Joined: Mon Mar 04, 2013 4:03 pm

regular expressions in SQLite

Post by danielrr » Fri Mar 18, 2016 12:07 pm

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
Posts: 1575
Joined: Tue May 28, 2013 2:20 pm
Location: Italy
Contact:

Re: regular expressions in SQLite

Post by MaxV » Thu Apr 14, 2016 3:27 pm

SQLite already supports the REGEXP operator:

Code: Select all

SELECT * FROM mytable WHERE myColumn REGEXP <regex>
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w

Post Reply

Return to “Databases”