vereperrot/sqlite select ignore case.sql

Created December 1, 2015 10:30

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/vereperrot/5d6a46d3e5793dda660b.js"></script>
Save vereperrot/5d6a46d3e5793dda660b to your computer and use it in GitHub Desktop.

Download ZIP

http://stackoverflow.com/questions/973541/how-to-set-sqlite3-to-be-case-insensitive-when-string-comparing

Raw

sqlite select ignore case.sql

SELECT * FROM ... WHERE name = 'someone' COLLATE NOCASE

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment