I'm still very new to this so forgive me. I'm normally a 2nd deskside support engineer for general PC issues, but due to being out of work thought I would try and expand my skillset.
I have a statement:
SELECT * FROM `TABLE 1` WHERE `Colour` LIKE 'Red' AND `Location` LIKE 'London-My'
It's not quite clear what you meant by "change multiple values", but
if you wanted to actually update the data:
UPDATE `TABLE 1` SET `Location` = 'London Docklands' WHERE `Colour` LIKE 'Red' AND `Location` LIKE 'London-My'
if you just needed to change the values in the returned resultset:
SELECT 'London Docklands' AS `Location`, `Colour` -- other needed columns go here FROM `TABLE 1` WHERE `Colour` LIKE 'Red' AND `Location` LIKE 'London-My'