SQL: How to select data from a field where an array is stored?

Question

SQL

Hello everyone, help me to correctly compose a sql query.
I have a table Products (goods)
There is a field Color (colors) - field type = text
The data in the colors field is stored in this form:

1: red
2: blue
3: green
...

How to make a selection from the database if the user selected the color Red (ID = 1) in the filter form
What to write in WHERE?
SELECT * from goods WHERE colors = ?

Answer 1

Understand the normal forms on which relational databases should be built and bring the database into the proper state, and then all such questions will disappear