update a column with data from another column

[John Biddulph]

Hi,

So I have an address column in my database but the whole address is in there, like this:

1 the street, town, county

I just managed to get the county out:

```
SELECT trim(SUBSTRING_INDEX(SUBSTRING_INDEX(address, ',', 4), ',', -1)) AS county FROM pubsuk.mypubs;
```

I would however like to UPDATE my county column with the SELECT statement above please help