mabog Posted September 8, 2010 Share Posted September 8, 2010 I need to search short words, like "4 x 4". Actually it's should act like one word, five letters long. But cannot find the right syntax.. Is it even possible? Query is now like this: SELECT * FROM car WHERE MATCH ( car.name ) AGAINST ( "\"4 x 4\"" IN BOOLEAN MODE ) CREATE TABLE `car` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '<empty>', PRIMARY KEY (`id`), FULLTEXT KEY `name` (`name`) ) ; INSERT INTO `car` (`id`, `name`) VALUES (1, '4 x 4'); Link to comment https://forums.phpfreaks.com/topic/212841-matching-short-words/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.