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.
This post was published by Daniyal Hamid. Daniyal currently works as the Head of Engineering in Germany and has 20+ years of experience in software engineering, design and marketing. Please show your love and support by sharing this post.