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]
