id summary reporter owner description type status priority milestone component version severity resolution keywords cc 4823 Add support for REGEXP keyword in sqlite/spatialite databases asuchander Even Rouault "Currently, in order to use the regex operator with spatialite one needs to load the pcre extension (https://github.com/oojah/sqlite3-pcre.git) . Unfortunately, OGR doesn't provide a mechanism to do this when it loads a sqlite database. That means that SQL queries using REGEXP cannot be used. This also breaks support for views (such as {{{ 'CREATE VIEW wms_view as SELECT ""shapefile_4864"".""gid"", ""shapefile_4864"".""lease_numb"", ""shapefile_4864"".""sale_numbe"", ""shapefile_4864"".""shape_area"", ""shapefile_4864"".""shape_fid"", ""shapefile_4864"".""the_geom"", ""shapefile_4864"".""web_geometry"" FROM ""shapefile_4864"" WHERE ""shapefile_4864"".""lease_numb"" REGEXP \'(?i)\' || 'Y019' ORDER BY ""shapefile_4864"".""gid"" ASC' }}} ), which might depend on the regexp operator Per EvenR: The source code is so small (and public domain) that it might be simpler to integrate it into OGR itself. Perhaps it can be integrated as a feature (always support REGEXP in sqlite/spatialite databases?) " enhancement closed normal 1.10.0 OGR_SF unspecified normal fixed sqlite