I'm trying to run a fulltext match against a product database, where the product names have forward slashes in them. These are staple sizes, so it's quite important that they get matched.
However, for every query I execute with a forward slash, I get 0 results.
The query I'm using is:
SELECT `product`.* FROM `product` WHERE MATCH (`product`.`name`) AGAINST('26/6')
I have also tried
SELECT `product`.* FROM `product` WHERE MATCH (`product`.`name`) AGAINST('\"26/6\"')
However, running the following returns 6 results, as expected:
SELECT `product`.* FROM (`product`) WHERE `product`.`name` LIKE '%26/6%'
The table is MyISAM and the product.name is varchar(255), with a FULLTEXT index on that column alone. If I search using fulltext for something else, like 'tool', I get the results as expected, and the server is configured for 4 character or more matching.
What do I need to do to make this fulltext match work?