appending to longtext field

Hello all, I have a database with a type longtext called notes. Say I wanted to append some text to this field, what command would I use? I have tried the following sql.. update clients set notes=notes+text to append where id=1; But this doesn't seem to do the job. I am new to MySQL so

Re: appending to longtext field

I think is better to have an additional record each time a user inserts new information Mr Orange wrote: Hello all, I have a database with a type longtext called notes. Say I wanted to append some text to this field, what command would I use? I have tried the following sql.. update clients

Re: appending to longtext field

GV wrote: I think is better to have an additional record each time a user inserts new information Mr Orange wrote: Hello all, I have a database with a type longtext called notes. Say I wanted to append some text to this field, what command would I use? I have tried the following sql..

Re: appending to longtext field

At 1:50 + 3/20/03, Mr Orange wrote: GV wrote: I think is better to have an additional record each time a user inserts new information Mr Orange wrote: Hello all, I have a database with a type longtext called notes. Say I wanted to append some text to this field, what command would I