On Thu, 29 Nov 2001, nut sss wrote: > can i do this? > content in field="aaa,bbb,ccc,hhh" > new content ="aaa,bbb,ccc,hhh,fff" > can i append new word "fff" into the old field .by > use update command in 1 query :) > it's like > "UPDATE persondata SET age=age+1" > but i want to append new value into old field... > what should i do .....
First of all: Read The very Fine Manual, especially the section on String Functions where you might find something about `CONCAT(str1,str2,...)' and CONCAT_WS(separator, str1, str2,...). Thomas --------------------------------------------------------------------- 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