Postgresql: find multiple records from comma separated column

Question

I am using PostgreSQL with Laravel 8.

In a Postgres table, I have one comma separated character varying column

I need those records from this table where value of this comma separated column is 43 OR 56 OR 252.

That is a really bad design decision. Do you have a chance to fix the broken data model before proceeding? — user330315
– user330315, Commented Sep 2, 2022 at 12:13

user330315 · Accepted Answer · 2022-09-02 12:15:42Z

2

Storing comma separated values in a single column is a huge mistake to begin with. But if you can't change the data model, you can achieve what you want by converting the value into an array, then use the array overlaps operator && with the values you want to test for:

select *
from the_table
where string_to_array(bad_column, ',')::int[] && array[43, 56, 252];

answered Sep 2, 2022 at 12:15

user330315

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

Collectives™ on Stack Overflow

Postgresql: find multiple records from comma separated column

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