Search based on a string list?

Hey! I'm experimenting more with the list type. I'm creating a job board, where one of the values is "listing.workplaces" where workplaces is a string list that can be one of a few values: "remote, on-site, hybrid"

is there an operator I can use to check which listing.workplaces contain the string "remote" ? I tried using the given "contains" operator but that doesn't apply to string lists.

If you think I should just create a separate table to hold these values, or keep them as a string comma separated string, would love to know.

SUMMARY: can you search a table based on a certain string value within a string list type?

Thanks so much!

2 replies