Yuvaan Chauhan Yuvaan Chauhan - 2 months ago 6
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

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