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 set notes=notes+"text to append" where id=1;
But this doesn't seem to do the job.
I am new to MySQL so sorry if I've asked an obvious question!
Many thanks in advance,
Steve.
PS. What is needed is a database to store notes on each client which can be added to as necessary. If anyone has a better idea of a way to do this, I'd be very grateful for any help! Cheers.
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
