database update question
| From: | chip dot wiegand at simrad dot com | Date: | Fri, 15 Nov 2002 22:40:00 +0000 |
| Subject: | database update question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23410@lists.php.net to get a copy of this message | ||
I have a database with several hundred entries of file names that end with
.pdf. I have converted
all those docs to .zip, now I need to change all the entries in the
database to .zip. I tried to use
update table_name set col_name='%.zip' where col_name like '%.pdf' && id
= '11'
but of course that changed the file name for id 11 to %.zip. Is there a way
to change all the
entries from .pdf to .zip without writing an update statement for each
individual row?
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
chip.wiegand@simrad.com
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairman and founder of Digital Equipment
Corporation, 1977
(They why do I have 8? Somebody help me!)