select * from `cars` where
(TRIM(REPLACE(`oilcode`,'-','')) = 'A0899') or
(TRIM(REPLACE(`aircode`,'-','')) = 'A0899') or
(TRIM(REPLACE(`fuelcode`,'-','')) = 'A0899') or
(TRIM(REPLACE(`cabincode`,'-','')) = 'A0899') or
(TRIM(REPLACE(`otherCode`,'-','')) like '%~A0899~%') or
(TRIM(REPLACE(`oilcode`,'-','')) like '%~A0899~%') or
(TRIM(REPLACE(`aircode`,'-','')) like '%~A0899~%') or
(TRIM(REPLACE(`fuelcode`,'-','')) like '%~A0899~%') or
(TRIM(REPLACE(`cabincode`,'-','')) like '%~A0899~%')
or TRIM(REPLACE(`oiloem`,'-','')) = '1109108XGW04A' or
TRIM(REPLACE(`airoem`,'-','')) = '1109108XGW04A' or
TRIM(REPLACE(`fueloem`,'-','')) = '1109108XGW04A' or
TRIM(REPLACE(`cabinoem`,'-','')) = '1109108XGW04A'
ORDER BY `cars`.`uin` ASC
Воздушный фильтр MADFIL A-0899
