Thank you so much LARRY BRASTFIELD for your quick reply, understanding of the matter and kind suggestions. I would definitely dive deep into JOIN commands as well as DATABASE NORMALIZATION to explore more about handling data efficiently. As you pointed out the need of another table having set of criteria and then running a query with JOIN command, the partner_sku is basically a uniquie product id in this catalogue table and other columns are having some related information like price, barcode etc. The first 3-4 letters of partner_sku are similar for a bunch of items because they are variants of same item which is the basis of my filtration say 'A1012'. Look below the few result of my query. I am trying here to pass the query with few letters of some items to get desired set of product_sku. I believe the above make some sense. +--------------+ | partner_sku | +--------------+ | A1012-20_BGN | | A1012-20_BLK | | A1012-20_BLU | | A1012-20_ROS | | A1012-20_PNK | | A1012-24_BGN | | A1012-24_BLU | | A1012-24_ROS | | A1012-24_PNK | | A1012-24_BLK | | A1012-28_BLU | | A1012-28_BGN | | A1012-28_PNK | | A1012-28_ROS | | A1012-28_BLK | | A1012-3_BGN | | A1012-3_BLU | | A1012-3_BLK | | A1012-3_ROS | | A1012-3_PNK | | A1012-32_ROS | | A1012-32_BLU | | A1012-32_BGN | | A1012-32_BLK | | A1012-32_PNK | | A1012-4_ROS | | A1012-4_BLK | | A1012-4_BLU | | A1012-4_PNK | | A1012-4_BGN |