Re: database update question
| From: | Joshua Stein | Date: | Fri, 15 Nov 2002 17:05:20 +0000 |
| Subject: | Re: database update question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23383@lists.php.net to get a copy of this message | ||
> Is there a way to change all the entries from .pdf to .zip without
> writing an update statement for each individual row?
UPDATE table_name SET col_name = LEFT(col_name, LEN(col_name) - 4) +
'.zip' WHERE col_name LIKE '%.pdf'
-j.