In mysql I'm having a column with full text indexing. Search is running fine for everything except for this row
ASP.NET and LINQ
Any query on the word "asp.net" would never return anything.
i used search strings like below but all would not yield any result -
SELECT * FROM job_posts WHERE MATCH(description) AGAINST ('+"asp.*"' IN BOOLEAN MODE);
SELECT * FROM job_posts WHERE MATCH(description) AGAINST ('+"asp.net" +linq' IN BOOLEAN MODE);
SELECT * FROM job_posts WHERE MATCH(description) AGAINST ('+"asp.*" +linq' IN BOOLEAN MODE);
SELECT * FROM job_posts WHERE MATCH(description) AGAINST ('+"asp.net"' IN BOOLEAN MODE);
SELECT * FROM job_posts WHERE MATCH(description) AGAINST ('"ASP.NET"' IN BOOLEAN MODE);
View the online editor here
the table structure as is below
CREATE TABLE `job_posts` (
`job_id` bigint NOT NULL AUTO_INCREMENT,
`title` text COLLATE utf8mb4_bin,
`description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
`state` bigint DEFAULT NULL,
`country` bigint DEFAULT NULL,
`email` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
`city` bigint DEFAULT NULL,
PRIMARY KEY (`job_id`),
FULLTEXT KEY `full_text` (`description`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
insert into job_posts (title, description,state, country, city, email ) values ('.NET Developer' , 'ASP.NET and LINQ' , 44, 2, 7755 , 'xyz');
