How to find array value in database?

Question

PHP

Good afternoon.
The database has a table `events` (Events) in which there is a field `categories` ( Categories of events )
in the categories field there is an array with category identifiers of this format ["1", "2", "3", etc.].
The question is how you can display the event knowing the category id.
I tried to solve the problem in this way:

$result = $db->query('SELECT * FROM events WHERE categories LIKE "%'.$category_id.'%" ');

However, this method does not work properly.
Thank you in advance for your help.

Answer 1

implemented through the pop, well, if not refactor, then
and it's sad

Answer 2

You need to use where categories in ('.implode(",", $category_id).')