SELECT DISTINCT search_index1.Part_Number,
MATCH (`full_vehicle` , `long_description`) AGAINST ('25116f?mk=' IN BOOLEAN MODE ) AS rev
FROM hotchkis406.search_index1
left join hotchkis406.item_segment itsg on search_index1.Part_Number=itsg.Part_Number and discontinueFlag!='D'
WHERE (long_description LIKE '%25116f?mk=%' OR full_vehicle LIKE '%25116f?mk=%' OR search_index1.Part_Number LIKE '%25116f?mk=%')
OR (
MATCH (
`full_vehicle` , `long_description`
)
AGAINST (
'25116f?mk='
IN BOOLEAN
MODE
)
)
order by
rev DESC
LIMIT 0,12
NO RESULTS FOUND.
Search Keyword: 25116F?mk=
No results found
