So I want to make an update in MySQL where ... So I have data in columns name and status. If the name and status match foo and d, then I want to change foo to foo2 Code: UPDATE 'table1' WHERE ...