PostgreSQL - How to match a value in a table where column has values with comma separation

Question

I have a table with the following field values:

I want to do a select where I can match a value from this keyword column. For example:

SELECT templateid FROM public.templates WHERE keyword='Yes'

I don't want to use LIKE because in the case one of the comma-separated values is Yessy then I will get a return and that's not correct.

It has to be an exact match of one of the comma separated values.

Any clue?

That's a horrible database design. Do you have a chance to fix this before you continue? — user330315
– user330315, Commented Nov 12, 2021 at 15:02
yes I can change that, what do you recommend me? Appreciate it — VAAA
– VAAA, Commented Nov 12, 2021 at 16:23

user330315 · Accepted Answer · 2021-11-12 15:03:56Z

1

You can convert the string into an array:

SELECT templateid 
FROM public.templates 
WHERE 'Yes' = any(string_to_array(keyword, ','))

answered Nov 12, 2021 at 15:03

user330315

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

1 Answer 1