PostgreSQL: Partial match between string columns

Question

I have the following code:

with my_table (id, col_1, col_2)
as (values 
(1, '$ (USD)', '$ (USD) million'),
(2, '$ (USD)', '$ (USD)'),
(3, 'USD', '$ (USD)'),
(4, 'EUR', '$ (USD)')
)

select *,
     case when col_1 = col_2 then 'TRUE'
     else 'FALSE'
     end as is_a_match
from my_table

the output:

id   col_1      col_2              is_a_match
1    $ (USD)    $ (USD) million    FALSE
2    $ (USD)    $ (USD)            TRUE
3    USD        $ (USD)            FALSE
4    EUR        $ (USD)            FALSE

how can I edit the query so I get id 1,2,3 as TRUE and id 4 as FALSE? I would like it to be generic, so if there are other currencies it can also look for a partial match.

user330315 · Accepted Answer · 2022-04-27 11:21:50Z

2

You can use strpos() to check if the string in col_1 occurs anywhere in col_2:

select *,
       strpos(col_2, col_1) > 0 as is_a_match
from my_table

answered Apr 27, 2022 at 11:21

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL: Partial match between string columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related