Ignore case in query to SQL database
android, sql, sqlite
Solution
Use this:
SELECT * FROM TableName WHERE col_name COLLATE NOCASE ="namehascapsinit"
Problem
I can't find a good example but if the name in the database is "namehascapsinit", It doesn't return anything. Is there anyway to ignore case? ``` String selection = MyTable.COL_NAME + " = ?"; String[] selectionArgs = new String[]{ "NameHasCapsInIt" }; c = getActivity().getContentResolver().query(MyTable.CONTENT_URI, null, selection, selectionArgs, null); ``` Thank in advance!