匹配多个单词和或不在codeigniter模型中工作

Question

I have one table like below ,table name is js_skills_achievements

id   skill1  skill2  skill3  skill4
1     java    php    html    android
2     php     java   jquery  html
3     sql     php    html    jquery

When admin search key is "java developer"

SELECT * FROM js_skills_achievements
WHERE MATCH(skill1,skill2,skill3,skill4) AGAINST ('java developer');

Its working for me , BUT I NEED MULTIPLE KEYWORDS not Working below QUERY

SELECT * FROM js_skills_achievements
    WHERE MATCH (js_skills_achievements.skill1,js_skills_achievements.skill2,js_skills_achievements.skill3,js_skills_achievements.skill4) AGAINST('java developer') OR (MATCH (js_skills_achievements.skill1,js_skills_achievements.skill2,js_skills_achievements.skill3,js_skills_achievements.skill4) AGAINST('php developer')

//This is Also not working
SELECT * FROM js_skills_achievements
WHERE MATCH(skill1,skill2,skill3,skill4) AGAINST ('java developer','php developer');

Please any one help me.

Answer 1

Try it like this:

SELECT * FROM js_skills_achievements
WHERE MATCH(skill1,skill2,skill3,skill4) AGAINST ('java developer php developer');

MATCH AGAINST takes only 1 input. So, you can include both of the string in that 1 input.