I posted a question and details on S/O
If I use one text column to store multiple string values
I will store it as comma separated string
assuming those value will never contain comma
Then a “contain” query can be implemented using “like”
But I am not sure how you store the array yet
its stored as a string
What’s the format?
You could use LIKE, but I think SO already gave you that answer. Depending on the database, you could have other options; Postgresql, for example, has built in text indexing that you could use. You could extract the individual array values and store them in another table.