In order to retrieve rows from a table in a mysql database, where the column id is equal to 2, 4, 6, 8,....., can someone suggest alternative ways in which these values can be searched for without using IN. I guess we can use OR but is there ant other way? In order to retrieve rows from a table in a mys