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'

```

This returns a handful of results. 

How do I then change these results say to change the value of (for example) Location: London-My to a new location(Say London Docklands)?

Sorry to ask, I can find how to change multiple values but not from a multi value result as above.