Comma Separate text filter not working

Get Help
1

comma separated text filter not working.

select location,  from `my-data-base` 
where location in ({{locations}})

type of locations is text.
it's working fine in case of single text. ex :- STAGE but not working for multiple texts.
STAGE,TABLE

2

Hi @arvind
It is not working because it's a quoted string {{locations}} becomes 'STAGE,TABLE' - if Metabase didn't do this, then you would be open to SQL injections.
You are looking for this - see the comments for workarounds for several database types:
https://github.com/metabase/metabase/issues/4728 - upvote by clicking :+1: on the first post