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.

Answer 1

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