select * from `cars` where
(TRIM(REPLACE(`oilcode`,'-','')) = 'AC25001') or
(TRIM(REPLACE(`aircode`,'-','')) = 'AC25001') or
(TRIM(REPLACE(`fuelcode`,'-','')) = 'AC25001') or
(TRIM(REPLACE(`cabincode`,'-','')) = 'AC25001') or
(TRIM(REPLACE(`otherCode`,'-','')) like '%~AC25001~%') or
(TRIM(REPLACE(`oilcode`,'-','')) like '%~AC25001~%') or
(TRIM(REPLACE(`aircode`,'-','')) like '%~AC25001~%') or
(TRIM(REPLACE(`fuelcode`,'-','')) like '%~AC25001~%') or
(TRIM(REPLACE(`cabincode`,'-','')) like '%~AC25001~%')
or
TRIM(REPLACE(`oilcode`,'-','')) = 'AC25001' or
TRIM(REPLACE(`aircode`,'-','')) = 'AC25001' or
TRIM(REPLACE(`fuelcode`,'-','')) = 'AC25001' or
TRIM(REPLACE(`cabincode`,'-','')) = 'AC25001'
or TRIM(REPLACE(`oiloem`,'-','')) = 'K015V9030' or
TRIM(REPLACE(`airoem`,'-','')) = 'K015V9030' or
TRIM(REPLACE(`fueloem`,'-','')) = 'K015V9030' or
TRIM(REPLACE(`cabinoem`,'-','')) = 'K015V9030'
ORDER BY `cars`.`uin` ASC
Салонный фильтр MADFIL AC-25001, VIC AC 407EX, FILTRON K1316