Fetch multiple records from single query

Question

Hello people here is my query

UPDATE `talent2db`.`talent_employee` SET `Rec_Status` = 'I' WHERE `talent_employee`.`Emp_Id` = '241074' AND `talent_employee`.`Rec_Status` = 'A' ;

UPDATE `talent2db`.`talent_employee` SET `Rec_Status` = 'I' WHERE `talent_employee`.`Emp_Id` = '785062' AND `talent_employee`.`Rec_Status` = 'A' ;

BY USING ABOVE QUERY IAM TRYING TO set "rec_status" to 'I' from 'A',as we can see we are trying to update for two employess with two different emp_ids... is it possible to update by writing only one query ...?? it should be something like

UPDATE `talent2db`.`talent_employee` SET `Rec_Status` = 'I' WHERE `talent_employee`.`Emp_Id` = '785062,241074' AND `talent_employee`.`Rec_Status` = 'A' ;

Pankaj Khairnar · Accepted Answer · 2012-11-25 16:52:53Z

1

You can use condtion like this (talent_employee.Emp_Id = '785062,241074' OR talent_employee.Emp_Id = '785062')

following is the actual query

UPDATE `talent2db`.`talent_employee` SET `Rec_Status` = 'I' WHERE (`talent_employee`.`Emp_Id` = '785062,241074' OR `talent_employee`.`Emp_Id` = '785062') AND `talent_employee`.`Rec_Status` = 'A' ;

edited Nov 25, 2012 at 16:52

answered Nov 25, 2012 at 16:50

Pankaj Khairnar

3,1363 gold badges28 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John Woo · Accepted Answer · 2012-11-25 16:51:08Z

0

try using IN clause.

UPDATE `talent2db`.`talent_employee` 
SET `Rec_Status` = 'I' 
WHERE `talent_employee`.`Emp_Id` IN ('785062','241074') AND 
      `talent_employee`.`Rec_Status` = 'A' ;

answered Nov 25, 2012 at 16:51

John Woo

265k70 gold badges509 silver badges500 bronze badges

Comments

max_ · Accepted Answer · 2012-11-25 16:50:18Z

0

Use the OR clause.

UPDATE `talent2db`.`talent_employee` 
SET    `rec_status` = 'I' 
WHERE  (`talent_employee`.`emp_id` = '785062' OR `talent_employee`.`emp_id` = '241074') 
AND `talent_employee`.`rec_status` = 'A';

answered Nov 25, 2012 at 16:50

max_

24.6k41 gold badges126 silver badges214 bronze badges

Collectives™ on Stack Overflow

Fetch multiple records from single query

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related