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

VIEW ALL

ASSIGN

HKD$ 1099

ASSIGN

HKD$ 1099

BECK MID

HKD$ 1099

COLORADO

HKD$ 1699

COLORADO

HKD$ 1699

CONRAD

HKD$ 1099

CONVEX MID ST

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