Your WHERE condition can be simplified like
UPDATE domain_information
SET company_name="aaa"
WHERE company_name="bbb";
2
solved i want to update table multiple row using IN statement
 
Your WHERE condition can be simplified like
UPDATE domain_information
SET company_name="aaa"
WHERE company_name="bbb";
2
solved i want to update table multiple row using IN statement