Query Android's SQLiteDatabase using Regex

Question

I am trying to fetch entries from a SQLiteDatabase in an Android program using the query function using the selection parameter. I have had success with simple pattern matching using the SQLite's LIKE and the % wildcard. Now I want to do more complex pattern matching using regular expressions.

According to the SQLite website, for the REGEXP operator to function, it must be user defined. Has anyone had any success creating use defined SQLite functions for Android's SQLiteDatabase? Or has anyone found another way to use regular expressions when searching through strings in a database?

I imagine getting SQLite to use user defined functions in Android would be tricky, although I guess it might be possible with NDK — antlersoft
– antlersoft, Commented Jul 1, 2011 at 14:44

pawelzieba · Accepted Answer · 2011-07-01 15:09:09Z

1

As described here

The REGEXP operator is a special syntax for the regexp() user function. No regexp() user function is defined by default and so use of the REGEXP operator will normally result in an error message. If a application-defined SQL function named "regexp" is added at run-time, that function will be called in order to implement the REGEXP operator.

But there is GLOB which is little more advanced than LIKE.

answered Jul 1, 2011 at 15:09

pawelzieba

16.1k3 gold badges48 silver badges72 bronze badges

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

1 Comment

gelakinetic Over a year ago

GLOB looks promising, I'll give that a shot later. Thanks!

Collectives™ on Stack Overflow

Query Android's SQLiteDatabase using Regex

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related