select * from products where (category LIKE ',157%' OR category LIKE '%157%' OR category LIKE '%157') and status='Enabled' ORDER BY name_eng ASC

ROAMER MID

HKD$ 998

ROAMER MID

HKD$ 998