Re: UPDATE query to add to a field
| From: | Joffrey van Wageningen | Date: | Mon, 28 Jan 2002 17:15:38 +0000 |
| Subject: | Re: UPDATE query to add to a field | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16255@lists.php.net to get a copy of this message | ||
> 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