Combining LIKE with IN in SQL

Question

Instead of executing:

SELECT a
FROM b
WHERE a LIKE 'a%'
OR a LIKE 'b%'
OR a LIKE 'c%'


is there a way to execute something functioning like this pseudocode?

SELECT a
FROM b
WHERE a IN ('a%', 'b%', 'c%')

Answer 1

Might be too specific to your example, but you could do LIKE '[a-c]%'. Other than that, I'm not aware of any LIKE-like IN syntax