October 2008
1 post
Mysql fulltext indexes and html entities
Using the builtin myisam fulltext index to search for text in a table with htmlencoded text gives bit of a strange results. Perhaps it could be expected, but for convenience, it would have been nice to have it working…but apparently its not…
The following table
CREATE TABLE `texts` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`content` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY ...