php - 匹配多个单词 AND OR 在 codeigniter 模型中不起作用

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 个输入。因此，您可以在该 1 个输入中包含两个字符串。