is there any combination of 'in' and 'like' operator.

Question

string shape = " 'round', ' pearl', 'oval', 'heart', 'princess'  ";

 

//  first query - select * from table1 where shape in (" + shapes + ")

// second query - select * from table1 where shape like '%Pear%'";

 

now i want to use 'like' parameter for all  other shape.
in short how can i use combination of 'like' and 'in' operator.

Thanks in advance.