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