Filter for 'contains any' for an array column, searching by an array
I have a text[] column that contains tags, and i want to return all rows in my table that have ANY of the user's selected tags. at the moment i'm using contains(), but that only returns rows that have ALL the tags. how can i make this work? thanks!
