How to enable MATCH operator in sqlite

Question

I'm newly in sqlite. I installed sqlite on my ubuntu machine. When I want to search in a table with MATCH operator I get the following error:

Result: unable to use function MATCH in the requested context

I also followed this post, but it didn't work.

The question is: How can I enable using MATCH operator in sqlite for my ubuntu machine?

Thanks.

Answer 1

In a standard sqlite table you would need to implement the MATCH operator - see https://sqlite.org/lang_expr.html#the_like_glob_regexp_match_and_extract_operators

I've had a go at writing an extension that enables a match operator - the idea is to extract that part of a string caught by the regular expression.

However, you need to compile this yourself using gcc and g++. See https://github.com/njamescouk/matchExtension for more details.