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 th
> 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 M
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 + "mor
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 to tack on to end"
but this is a mathematical f
