I know what I want to do, however I don't now how to do it, or if Im
doing it right.

Im running an update and I need to add text to a field and keep the
text that was already their in order of "new text"+"old text".


So I have this query I wrote, however as its a live db I cant chance
the mistake.

UPDATE users SET levels = 0, mbox = 0, notes = ? + notes WHERE
subscription_id = ? LIMIT 1

* Question marks are converted via php to their values.

Levi

NVM I found what I needed.

For anyone else you need CONCAT()

On 12 Oct, 16:06, l3vi <ad...@madfrogproductions.com> wrote:
> NVM I found what I needed.
>
> For anyone else you need CONCAT()

You also need "there" instead of "their"