CODEWITHSUNDEEP
sqloracle-database
KNathan
KNathan

Reputation: 31

Query to fetch from a column having multiple values and compare with another column

I would like to compare a Column A with Column B where

Column A      
  "joe" 

Column B 
  BAK_LOGIN:YBAK_SUB_ACCT:joeBAK_SRVID:BasicBAK_QUOTA_EXCEEDED:Y

So the second subfield BAK_SUB_ACCT:joe must be compared with Column A.

How do i do this?

Thanks&Regards,

Kumar

Upvotes: 0

Views: 101

Answers (1)

San
San

Reputation: 4538

You can use like operator

WHERE columnB like '%BAK_SUB_ACCT:'||columnA||'%'

Upvotes: 1

Related Questions