[Solved] In operator alternative in mysql

using IN operator should NOT have performance issues.

If you insist NOT using IN operator, replace your query with:

Select col1,col2,col3 from table1 where col4=1 OR col4=2 OR col4=3 OR col4=4;