select * from `cars` where
(TRIM(REPLACE(`oilcode`,'-','')) = 'MO901') or
(TRIM(REPLACE(`aircode`,'-','')) = 'MO901') or
(TRIM(REPLACE(`fuelcode`,'-','')) = 'MO901') or
(TRIM(REPLACE(`cabincode`,'-','')) = 'MO901') or
(TRIM(REPLACE(`otherCode`,'-','')) like '%~MO901~%') or
(TRIM(REPLACE(`oilcode`,'-','')) like '%~MO901~%') or
(TRIM(REPLACE(`aircode`,'-','')) like '%~MO901~%') or
(TRIM(REPLACE(`fuelcode`,'-','')) like '%~MO901~%') or
(TRIM(REPLACE(`cabincode`,'-','')) like '%~MO901~%')
or
TRIM(REPLACE(`oilcode`,'-','')) = 'MO901' or
TRIM(REPLACE(`aircode`,'-','')) = 'MO901' or
TRIM(REPLACE(`fuelcode`,'-','')) = 'MO901' or
TRIM(REPLACE(`cabincode`,'-','')) = 'MO901'
or TRIM(REPLACE(`oiloem`,'-','')) = '15400679004' or
TRIM(REPLACE(`airoem`,'-','')) = '15400679004' or
TRIM(REPLACE(`fueloem`,'-','')) = '15400679004' or
TRIM(REPLACE(`cabinoem`,'-','')) = '15400679004'
ORDER BY `cars`.`uin` ASC
Масляный фильтр MADFIL MO-901, VIC C901, FILTRON OP595, MANN W6107