我正在开发工作门户网站应用程序。
雇员们正在登记他们的资格。
在员工成功注册后,
在两个条件下添加带有资格的职务。
呃,还有,或者是案子。
假设一份具有两项条件的工作,条件如下。
Engineering | Btech | Mechanical Engineering | regular | 80 %
Diploma | CAD | Computer Applications | Distance | 70%Engineering | Btech | Mechanical Engineering | regular | 80 %
Diploma | | | | 70%在进入工作资格后,我就像一个数组一样收集这些信息。
$a = ["27","26"]; // dummy data
$b = ["62"]; // dummy data
$c = ["59"]; // dummy data我希望从符合上述条件的员工资格表中收集员工ID数据。

我在下面的查询中尝试了Where。
SELECT * FROM `otc_employee_qualifications`
WHERE `emp_qualifctn_type` IN ('26','27')
AND `qualification_value` IN ('59','32')
AND `emp_qualifctn_branch` IN ('156')
AND `emp_qualifctn_stream` IN ('2')
AND `qualification_mark` >= 27
GROUP BY `employee_id` 发布于 2015-11-25 05:48:40
尝试使用AND而不是where来连接两个条件。
SELECT * FROM `otc_employee_qualifications`
WHERE `emp_qualifctn_type` IN ('26','27')
AND `qualification_value` IN ('59','32')
AND `emp_qualifctn_branch` IN ('156')
AND `emp_qualifctn_stream` IN ('2')
AND `qualification_mark` >= 27
GROUP BY `employee_id` 发布于 2015-11-25 05:48:46
使用地点及之后
SELECT * FROM `otc_employee_qualifications`
WHERE `emp_qualifctn_type` IN ('26','27')
AND `qualification_value` IN ('59','32')
AND `emp_qualifctn_branch` IN ('156')
AND `emp_qualifctn_stream` IN ('2')
AND `qualification_mark` >= 27
GROUP BY `employee_id` 发布于 2015-11-25 05:49:40
使用和更改条件
SELECT * FROM `otc_employee_qualifications`
WHERE `emp_qualifctn_type` IN ('26','27')
AND `qualification_value` IN ('59','32')
AND `emp_qualifctn_branch` IN ('156')
AND `emp_qualifctn_stream` IN ('2')
AND `qualification_mark` >= 27
GROUP BY `employee_id` https://stackoverflow.com/questions/33909256
复制相似问题