Yuvaan Chauhan Yuvaan Chauhan - 7 months ago 28
SQL Question

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

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

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