SQL – Update multiple records in one query
Try either multi-table update syntax Here is SQLFiddle demo or conditional update Here is SQLFiddle demo
Try either multi-table update syntax Here is SQLFiddle demo or conditional update Here is SQLFiddle demo
Try either multi-table update syntax Here is SQLFiddle demo or conditional update Here is SQLFiddle demo