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

NEW ARRIVALS

ASSIGN

HKD$ 1099

ASSIGN

HKD$ 1099

COLORADO

HKD$ 1699

COLORADO

HKD$ 1699

CRUZ

HKD$ 1099

DREXEL

HKD$ 998

DREXEL

HKD$ 998

EBB

HKD$ 899

EBB

HKD$ 899

EON

HKD$ 1099

EON

HKD$ 1099

FILTER GORE-TEX

HKD$ 1399

FILTER GORE-TEX

HKD$ 1399

FOUNDER

HKD$ 1599

FOUNDER

HKD$ 1599

FOUNDER

HKD$ 1599

ROAMER LO

HKD$ 899

ROAMER LO

HKD$ 899

ROAMER MID

HKD$ 998

ROAMER MID

HKD$ 998

UNEXPECTED

HKD$ 899

UNEXPECTED

HKD$ 899