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` ) ; |
Leave a Reply