concatenate values from two columns and compare it against one value in sqlite

Question

I am using sqlite in one my ios project where among other columns there are two columns. one has country code for mobile dialing like +880 and other column has rest of the mobile number like 1912353697. Now i want to join values from these two columns and compare the result value against like +8801912353697 and if matches pull the corresponding name value in that table . what would be the right query. I have tried like SELECT name FROM CONTACT_LIST WHERE (SELECT mblDc || mbl FROM CONTACT_LIST) = "+8801617634317" ; but that does not work .

A help would be appreciated.

Why doesn't it work? Any error messages or is the result just incorrect? — Enrico Susatyo, Jun 10 '14 at 04:34
the corresponding name does not show up. result show all the value from name column @EnricoSusatyo — sujat, Jun 10 '14 at 04:38

score 1 · Accepted Answer · answered Jun 10 '14 at 04:37

1

Try:

SELECT name FROM CONTACT_LIST 
WHERE mblDc || mbl = "+8801617634317";

From SQLite documentation: The || operator is "concatenate" - it joins together the two strings of its operands.

answered Jun 10 '14 at 04:37

MinhD

1,790
11
14

score 0 · Answer 2 · edited May 23 '17 at 11:57

0

please check How to concatenate strings with padding in sqlite

using substr function we can do the job and the query should be like

SELECT name FROM CONTACT_LIST WHERE  (mblDc || mbl) = "+8801617634317" ;

edited May 23 '17 at 11:57

Community

1
1

answered Jun 10 '14 at 04:43

Swarna Sekhar Dhar

550
1
8
25

concatenate values from two columns and compare it against one value in sqlite

2 Answers2