码点火器模型中的多字匹配与或不工作

Question

我有一个像下面这样的表，表名是js_skills_achievements

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

当管理搜索键为"java developer“时

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

它为我工作，但我需要多个关键字不工作下面的查询。

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');

请大家帮帮我。

Answer 1

试着这样做：

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

MATCH AGAINST只需要一个输入。因此，您可以在该1输入中包含这两个字符串。