Sqlite in C# with REGEXP

Question

I'm trying to build a search query to match whole words in SQLite and C# on Windows. When I run a query like this:

SELECT a, b FROM Events WHERE c REGEXP @SearchString;

Then:

cmd.Parameters.Add(new SQLiteParameter("@SearchString", 
"%[^a-zA-Z0-9]" + searchdata.SearchText + "[^a-zA-Z0-9]%"));

And when I call:

var r = cmd.ExecuteReader();

I get REGEXP no such function. I wonder how to activate REGEXP support and CASE SENSITIVE search.

Community · Accepted Answer · 2017-05-23 12:07:25Z

5

I've got it! The problem was that I didn't define the REGEXP function. I've got from here: here a definition for C#.

CommunityBot

11 silver badge

answered Dec 18, 2013 at 14:06

Pablo Yabo

2,8134 gold badges30 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniel A. White · Accepted Answer · 2013-12-17 01:01:29Z

0

You shouldn't need the %. That is only for LIKE.

answered Dec 17, 2013 at 1:01

Daniel A. White

192k49 gold badges389 silver badges473 bronze badges

The same error. The problem is the REGEXP not the parameter format. I think Konrad is correct to point me that something is missing but what?

@PabloYabo what version of sqlite are you using?

I'm using SQLite.NET 1.0.88.0 - August 7, 2013. SQLite 3.7.17

@PabloYabo ensure that it is in your build of sqlite.

How I should do that?