I try to filter multiple values in the same column in CartoDB. I then like to filter on another column.
I do not manage to filter on multiple values in one column in the graphical interface (one value ok, but more I see no way to do this).
I then write the SQL query:
SELECT * FROM bdi_adm2 WHERE name_1 ILIKE '%bururi%' OR name_1 ILIKE '%cancuzo%' OR name_1 ILIKE '%karuzi%' OR name_1 ILIKE '%makamba%' OR name_1 ILIKE '%rutana%' OR name_1 ILIKE '%ruyigi%'
But then I am not able to filter on another column (it tells me that I have to clear the selection first).
How can I filter through the input box for multiple values?