How to match value with comma in Sqlite Database with different column and return again with comma

Question

I have database with three column like here

code      name           details
nd      new dear        sdadasd
dn      no dear         fdsfdsf
bs      bhai sahab      vdfgdfgdfg

Now I have value with comma like

"nd, new dear"

How to match with different column in database and how to get same value from database

"nd, new dear"

Please suggest query.

Boris Schegolev · Accepted Answer · 2016-09-12T13:42:15.660

0

SELECT code || ', ' || details AS val
FROM mytable 
WHERE code || ', ' || details = 'nd, new dear'

edited Sep 12 '16 at 13:42

answered Sep 12 '16 at 13:19

Boris Schegolev

Thanks for comment Boris but i getting sql error : Exception Name: NS_ERROR_FAILURE Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement] but for fetching from table i am using" ( code||', '||name ) AS expr1 ". – Yuvaan Chauhan Sep 12 '16 at 13:29
now i want to match same value with comma from Database and return same with comma – Yuvaan Chauhan Sep 12 '16 at 13:31
And why are you using `code||', '||name`? It does not sound like MySQL syntax. Use `concat()` instead. – Boris Schegolev Sep 12 '16 at 13:36
yes this is not belongs to mysql i am using sqlite DB. – Yuvaan Chauhan Sep 12 '16 at 13:40

1 Answers1