Re: Appending records
| From: | GVerron | Date: | Fri, 01 Sep 2000 22:17:10 +0000 |
| Subject: | Re: Appending records | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-2576@lists.php.net to get a copy of this message | ||
Thank you very much. The following expression did the job:
UPDATE table SET field=CONCAT(field,",") WHERE field REGEXP "[^,]$";
Thanks to you I am getting familiar to mysql functions, and notably REGEXP.
Gerard Verron