MySQL and a list of values ​​in a table field. How to build a selection by condition?

Question

MySQL

There are tables like id, avID, value. The value field can contain both single values ​​and a comma-separated list of values.
There is a task to receive avID where value is equal to a certain variable.
Queries like:
SELECT avID FROM `atMultiPageSelector` WHERE VALUE LIKE '$param'
return an empty value.
Please tell me how to make a request.

Answer 1

The value field can contain both single values ​​and a comma-separated list of values.

You don't have to be shitty. Make a normal structure .