By Niranjan cc
Hello,
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 …
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hi @niranjanchowdam,
You’ll need to run the following query in order to use the FUlltext function
ALTER TABLE `js_skills_achievements` ADD FULLTEXT('skill1','skill2','skill3','skill4');
As soon you ran this query to actually alter the table, you should actually be able to run your query without a problem
SELECT * FROM js_skills_achievements
WHERE MATCH(skill1,skill2,skill3,skill4) AGAINST ('java developer in niranjankumar chowdam');
Regards, KDSys
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.