D 2019-08-10T23:34:50.481 J foundin 1.0.111.0 J icomment In\sorder\sto\suse\sthe\sREGEXP\sextension,\sit\smust\sbe\senabled\sfirst\s(i.e.\ssince\sit\sis\r\nan\sextension).\s\sThe\sfollowing\sC#\scode\ssnippet\sshows\sroughly\swhat\sis\srequired:\r\n\r\n\r\n\s\susing\s(SQLiteConnection\sconn\s=\snew\sSQLiteConnection())\r\n\s\s{\r\n\s\s\s\s\s\sconn.ConnectionString\s=\s"Data\sSource=:memory:;";\r\n\s\s\s\s\s\sconn.Open();\r\n\s\s\s\s\s\sconn.EnableExtensions(true);\r\n\s\s\s\s\s\sconn.LoadExtension("SQLite.Interop.dll",\s"sqlite3_regexp_init");\r\n\r\n\s\s\s\s\s\s//\r\n\s\s\s\s\s\s//\sFurther\scode\shere...\r\n\s\s\s\s\s\s//\r\n\s\s}\r\n J login mistachkin J mimetype text/x-fossil-wiki J priority Medium J resolution Works_As_Designed J status Closed J subsystem Connection J title How\sto\suse\sREGEXP\sextension... K b400a24aab4a529e80cabf6cdf815d8d6c9eadea U mistachkin Z 0d41b65711b69dc46cf0c10ed37d96b0