You can do case-insensitive matches with SQLite
NOT IN) operator by adding
COLLATE NOCASE operator after an expression (that's to the left of
NOT IN operators), for example, like so:
SELECT * FROM `table` WHERE `column` COLLATE NOCASE IN ('foo', 'bar')
This will match all (case-insensitive) variations of the values specified to the right of
NOT IN) operator.
Hope you found this post useful. It was published . Please show your love and support by sharing this post.