Am getting error in Database Searches with Full-Text Search in MySQL 5.7.2 on Ubuntu 16.04
Present am using PHP7 Mysql 5.7 version, Am getting error in this version, FULLTEXT not working . please find below error.
SQL query: Documentation
SELECT * FROM js_skills_achievements WHERE MATCH(skill1,skill2,skill3,skill4) AGAINST ('java developer in niranjankumar chowdam');
MySQL said: Documentation
1191 - Can’t find FULLTEXT index matching the column list
I added fulltext index to this table , This is Working in 5.5 version . But not working in 5.7 mysql . Where can i change the permission , Please give me solution for this …
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.