SELECT * FROM abc WHERE column1 IN (a1,b1,c1)
我想在这个选择查询中使用LIKE;如何用IN编写LIKE语句,类似于下面的查询：
SELECT * FROM abc WHERE column1 LIKE IN (a%,b%,c%)
select column1 from abc where column1 like 'a%' or column1 like 'b%' or column1 like 'c%'
