Mysql free text search

select

    concat(`make`, ' ', `model`, ' ', `style`, ' ', `transmission`, ' ', `exterior_color`) as v,

    match

        (`make`, `model`, `style`, `transmission`, `exterior_color`, `vehicle_features`, `body_style`)

    against

        ('BMW Black'  IN BOOLEAN MODE) as r

from

    vehicles

where

    match

        (`make`, `model`, `style`, `transmission`, `exterior_color`, `vehicle_features`, `body_style`)

    against

        ('BMW Black'  IN BOOLEAN MODE)

You would have to add fulltext index to make this working.

ALTER TABLE `vehicles` ADD FULLTEXT `search` ( `make` , `model` , `style` , `exterior_color` , `body_style` , `transmission` , `vehicle_features` ) ;