SQLite query to get distinct columns

I am trying to write a query where I need to check whether a value is not present in an array of strings returned by another nested query how can I do that,

For example I have to check whether,

1234 is present in [abc_1234,fgh_12345,ghi_5343]

Hence 1234 is present in string abc_1234 so I will not select 1234.