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.

Did you read [this question](http://stackoverflow.com/questions/5071601/how-do-i-use-regex-in-a-sqlite-query) and the answer from mivk? — Konrad Kokosa, Dec 16 '13 at 22:57

score 5 · Accepted Answer · edited May 23 '17 at 12:07

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#.

edited May 23 '17 at 12:07

Community

answered Dec 18 '13 at 14:06

Pablo Yabo

score 0 · Answer 2 · answered Dec 17 '13 at 01:01

0

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

answered Dec 17 '13 at 01:01

Daniel A. White

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? – Pablo Yabo Dec 17 '13 at 13:18
@PabloYabo what version of sqlite are you using? – Daniel A. White Dec 17 '13 at 13:18
I'm using SQLite.NET 1.0.88.0 - August 7, 2013. SQLite 3.7.17 – Pablo Yabo Dec 17 '13 at 13:54
@PabloYabo ensure that it is in your build of sqlite. – Daniel A. White Dec 17 '13 at 14:06
How I should do that? – Pablo Yabo Dec 18 '13 at 13:56

2 Answers2