Get query filters for text

Witti

Hey there!

I have a table called "posts" and in this table there is a column that is called "colors". The entries in this column are datatype text and could look like this: "black, brown, green"

Now I want to filter query this with an input of different colors for example like this:

{

"postcolor": "white, black"

}

In this example i should get all posts, that contain white or black anywhere in their color-column so for example these combinations:

"white, green, yellow"

"brown, black, white, red"

"green, blue, purple, white"

Is there any way I can do this? Thanks in advance for any help on this!