sqlite3 - update query - case insensitive

Question

I have used the following query for sqlite3 update.

UPDATE customer SET nameid = '0' where (a like '%aba%' or  b like '%aba%' or  c like '%aba%' or  d like '%aba%')  COLLATE NOCASE.

But In my tables, the respected column stores the value like ABA,Aba,ABa,aBA. I want to make update query with case insensitive. Kindly guide me , what mistake i have done.

The above query is not updating the tables.

THanks

`LIKE` is already case insensitive. Consider posting a more thorough example to demonstrate your problem. — laalto, Apr 08 '14 at 09:39
Hi Latto, LIKE is not working as case insensitive format. I am using the sqlite3 database in IOS. is there any difference ? — Finder, Apr 08 '14 at 10:02

score 1 · Answer 1 · edited May 23 '17 at 10:26

1

Try using the followin query:

UPDATE customer SET nameid = '0' where (LOWER(a) like '%aba%' or LOWER(b) like '%aba%' or LOWER(c) like '%aba%' or LOWER(d) like '%aba%')

Here is the link for similar question: Case sensitive and insensitive like in SQLite

edited May 23 '17 at 10:26

Community

1
1

answered Apr 08 '14 at 09:43

Stropharius

148
3

Hi, I could not use Lower and upper case method. because the '%aba%' will receive from the server. Sometimes they will pass lower/upper/mixed. I want to check the characters alone not cases. – Finder Apr 08 '14 at 10:00
You can use LOWER in like as well: '... like LOWER('%abc%')' – Stropharius Apr 08 '14 at 10:06

sqlite3 - update query - case insensitive

1 Answers1