Thanks @sid… delayed response but thought I’d share my own solutions here for future reference.
As i was using PostgreSQL, FIND_IN_SET isn’t an available option, and like your first link suggested, Postgres has the ANY function/syntax that can be used in a WHERE clause really easily.
The only issue, is that for me to make it work i needed the data that I was filtering on to be in the database somewhere so i could return it using a SELECT statement.
It ends up looking something like this:
SELECT
*
FROM
table.name
WHERE
filter_id = ANY (SELECT filter_ID from filter.table WHERE field = filter)
That’s just some random made up query, but the general idea is that you need to use a SELECT statement after the ANY clause and it needs to return a single column.
You can also use any standard operator before the ANY clause, like =, <>, < etc etc…
Hope this helps anyone looking.
https://www.postgresqltutorial.com/postgresql-any/