How to get values(via some conditions) from the MySql table without using ‘OR’?

It can be done as follows :

SELECT * FROM `table_name` WHERE `request_id` IN ('value1','value2','value3','value4');

The benefit of using IN() is that it can process data more faster than using OR condition.

Leave a Reply