MYSQL: Filtering by Column with array value

Question

I would like to ask how to filter a table by column with array value, I have a column "categories" that can have a value like [1,2,3] now I want to filter the table with that table like SELECT * FROM TABLE WHERE CATEGORIES = 2,

I also tried LIKE but it seems like it is not the proper way to do it, any opinions and suggestions would be appreciated.

@Hannyson it's not an array, it's just a text. It's mean that your DB schema is realy bad (-; — Neodan
– Neodan, Commented Oct 24, 2017 at 9:11

Dharmang · Accepted Answer · 2017-10-24 06:32:36Z

5

It is not recommended way to store comma separated values in Column which needs to be filtered for queries.

You can use normalization and introduce relationship tables for categories and category_ids to be stored in different tables, then you can use join and where clause to achieve your results.

answered Oct 24, 2017 at 6:32

Dharmang

3,03837 silver badges40 bronze badges

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

1 Comment

Hannyson Over a year ago

Will follow your advise then Sir Thank you.

Collectives™ on Stack Overflow

MYSQL: Filtering by Column with array value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related