REGEXP support for SQLite

[LNKLEO]

Just using a "SELECT [COLUMES] FROM [TABLE] WHERE [COLUME] REGEXP [EXPR]" statement

You will get an error "no such function REGEXP"

Database engine: SQLite

Visual Studio or SSMS version: VS 2022 + CEToolbox 4,8.776

[ErikEJ]

@LNKLEO Do you know in which sqlite version regexp was added?

[LNKLEO]

REGEXP was added in a very early version I think, and I noticed you using System.Data.SQLite as SQLite implement. Then I found this.

https://stackoverflow.com/questions/20622613/sqlite-in-c-sharp-with-regexp
https://stackoverflow.com/questions/172735/create-use-user-defined-functions-in-system-data-sqlite

It looks you need to create a REGEXP to archive this with System.Data.SQLite.