使用SQL，您可以在WHERE LIKE子句中使用子查询吗？

I'm not even sure how to even phrase this as it sounds weird conceptually, but I'll give it a try. Basically I'm looking for a way to create a query that is essentially a WHERE IN LIKE SELECT statement. I'm not even sure how to even phrase this as it