Simple one really - or should be.

I have multiple fields that I want to condense and append to one longtext field.

I'm guessing that this is a concat function but I don't know how to append concatenated values to a field in the same row with an existing value.

Is there a MySQL statement that will do the trick or will I have to run a looping php script?

Example...

```
ID | NAME | POSITION | NOTES
1 | Richard | Programmer | Not paid enough
2 | David | Manager | Lazy
3 | Hilary | Personnel Manager | Doesn't care

```

Ultimately, I want to delete the NAME and POSITION fields but I want to store those values beforehand so I want to concatenate " - ".NAME." - ".POSITION and append it to NOTES without losing any data from that field so the result would be...

```
ID | NAME | POSITION | NOTES
1 | Richard | Programmer | Not paid enough - Richard - Programmer
2 | David | Manager | Lazy - David - Manager
3 | Hilary | Personnel Manager | Doesn't care - Hilary - Personnel Manager

```

Does this make sense?