Yuvaan Chauhan Yuvaan Chauhan - 1 year ago 71
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 Source
SELECT code || ', ' || details AS val
FROM mytable 
WHERE code || ', ' || details = 'nd, new dear'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download