Need to change file extensions 1

[deecee]

I have a column in a table with image locations

filename.jpg

i need to change all the extensions to

filename.eps

what would be easier then deleting the column and adding an new column with all the info?

thanks

zzzzzz

 

[TonyGroves]

How about something like:
[tt]
UPDATE tbl SET fld=REPLACE(fld,'.jpg','.eps')
[/tt]


-----
ALTER world DROP injustice, ADD peace;

 

[deecee]

will this change the whole column -- asuuming colomn name is images -- how would this target that colomn

Select images FROM items UPDATE tbl SET fld=REPLACE(fld,'.jpg','.eps')

would this be correct to perform the required task?

zzzzzz

 

[TonyGroves]

Your suggestion will not work at all, it's not valid SQL.
[tt]
UPDATE tbl SET fld=REPLACE(fld,'.jpg','.eps')[/tt] will examine every record in the table called tbl, changing the value stored in the column named fld so that every occurrence of '.jpg' is changed to '.eps'.


-----
ALTER world DROP injustice, ADD peace;

 

[deecee]

but i only need one column -- i have other columns that point to thumbnails -- and larger images that i need to keep jpg.

the column that points to images for print need to be eps.

zzzzzz

 

[TonyGroves]

The SQL I posted will only affect the column named fld. All other columns will remain unchanged.

-----
ALTER world DROP injustice, ADD peace;