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

BRUISER

HKD$ 1599

CECE

HKD$ 998

CECE

HKD$ 998

OTTAWA

HKD$ 1699

POE

HKD$ 998

SUSPENSE

HKD$ 998