有没有办法在SQL语句中将IN与LIKE结合起来？

SELECT * FROM table_name WHERE column_name LIKE 'value1%' OR column_name LIKE 'value2%' OR column_name LIKE 'value3%';

SELECT * FROM table_name WHERE 
CASE 
    WHEN column_name LIKE 'value1%' THEN 1 
    WHEN column_name LIKE 'value2%' THEN 1 
    WHEN column_name LIKE 'value3%' THEN 1 
    ELSE 0 
END = 1;