CODEWITHSUNDEEP
androidsqlitewildcard
Alex Bonel
Alex Bonel

Reputation: 1424

Using wildcard charlist in android SQLite interaction

By this moment I've mentioned that using of wildcard charlist enclosed in square brackets ([]) when interact with android's sqlite is possible using GLOB statement, but the problem is that it's a case sensitive.

I would like to know is there any way to make GLOB case insensitive or some magic way to make LIKE statement be able to work with wildcard charlist in Android?

Thanks.

Upvotes: 0

Views: 907

Answers (1)

CL.
CL.

Reputation: 180030

LIKE does not support character lists.

You have to duplicate upper and lower case characters in the character list:

... WHERE Name GLOB '[XYZxyz]*'

Upvotes: 2

Related Questions