Like Function doesn't allow multiple entries

1

When I try to use the LIKE function but with Multiple entries.

So column1 like (‘B55%’,‘B77%’) I get an error message

Cannot apply ‘LIKE’ to arguments of type ‘LIKE(<VARCHAR(65536)>, <RECORDTYPE(VARCHAR(4) EXPR$0, VARCHAR(4) EXPR$1)>)’. Supported form(s): ‘LIKE(<STRING>, <STRING>, <STRING>)’

.

2

@sgoldsmith, if you’re on v23.1, try using the new LIKE ANY syntax

Something like:

SELECT * FROM "zips.json" WHERE city LIKE ANY ('B%','A%');

Else, you have to use OR operator, like:

SELECT * FROM "zips.json" WHERE city LIKE 'B%' OR city LIKE 'A%';