I am developing job portal web application..
Employees are registering with their qualifications.
After employees are registered successfully,
job adding with qualification on two conditions.
ie, AND , OR case.
Suppose a job having qualification with two AND Conditions like.
Engineering | Btech | Mechanical Engineering | regular | 80 %
Diploma | CAD | Computer Applications | Distance | 70%
Engineering | Btech | Mechanical Engineering | regular | 80 %
Diploma | | | | 70%
After entering job qualifications I am collecting that as an array like.
$a = ["27","26"]; // dummy data
$b = ["62"]; // dummy data
$c = ["59"]; // dummy data
I want to collect EMPLOYEE ID data from my employee qualifications table that matching the above condition.
I tried the Where In query like below.
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`
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire