There is a standard extension for the regexp function. You have to compile it yourself, however.
ext/misc/regexp.c in the source distribution. Then load the module. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf >Of Peng Yu >Sent: Friday, 6 September, 2019 10:44 >To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> >Subject: [sqlite] Is pcre available on homebrew? > >I'd like to use regex. > >https://stackoverflow.com/questions/5071601/how-do-i-use-regex-in-a-sqlite- >query > >But I don't find pcre. > >https://formulae.brew.sh/formula/sqlite > >Does anybody know how to make regex available for slqite3 installed by >homebrew? Thanks. > >-- >Regards, >Peng >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users