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 mathematical function which returns 0!
>
> Any ideas?


SET prod_desc = CONCAT( prod_desc, "more info to tack on to end" )

Manual: 6.3.2  String Functions

Regards,
=dn



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to