i want to update table multiple row using IN statement

Question

UPDATE domain_information
SET company_name = 'aaa'
where id in (select id from domain_information where company_name = 'bbb')

score 0 · Accepted Answer · answered Nov 21 '16 at 10:16

0

Your WHERE condition can be simplified like

UPDATE domain_information
SET company_name = 'aaa'
WHERE company_name = 'bbb';

answered Nov 21 '16 at 10:16

Rahul

As long as no 'bbb' id is null. – jarlh Nov 21 '16 at 10:18
@jarlh, Yes, that's a implicit assumption that the id OP referring to in post is primary key of the table. – Rahul Nov 21 '16 at 10:21

1 Answers1