At 9:06 -0800 1/28/02, Adv. Systems Design wrote:
hello all:
I need to be able to update a field in MySQL, the catch is that I
have to add on to text that is already there and I have to be able
to do it within MySQL (phpMyAdmin). My first idea was to do:
SET prod_desc = prod_desc + more info
SET prod_desc = prod_desc + more info to tack on to end
but this is a mathematical function which returns 0!
update table set field = concat(field, more info) where id = 1;
find the string functions in the mysql manual...
with kind regards,
Joffrey van Wageningen
--
PHP Database Mailing
Hello Adv. Systems Design,
I need to be able to update a field in MySQL, the catch is that I have to add on to
text that is already there
and I have to be able to do it within MySQL (phpMyAdmin). My first idea was to do:
SET prod_desc = prod_desc + more info to tack on to end
but this is a