[SOLVED] Changing a file name in a database?

[Solarpitch]

Hey guys,

 

I have a list of products in my database, about 2000 or so and they all have an image attached with it. The image path is in the format /imagename.jpg but I need to change them from a jpg to a gif.

 

Is there anyway I can change the ends of the filenames from .jpg to .gif across all 2000 products by running a script.

 

eg:

 

image1.jpg

image2.jpg

image3.jpg

 

........ run script

 

image1.gif

image2.gif

image3.gif

 

thanks

[trq]

UPDATE tbl SET fld = REPLACE(fld,'jpg','gif');

[Solarpitch]

Thanks for that. I ran...

 

UPDATE products SET product_image = STR_REPLACE(product_image,'jpg','gif');

 

but came back with..

 

#1305 - FUNCTION mpflooring.STR_REPLACE does not exist

[PFMaBiSmAd]

Edit: Basically the same as above ^^^

 

Assuming that the characters .jpg only appear once in any file name (you don't have anything like image123.jpg.jpg) and are always the same-case, then you can use the mysql REPLACE() function in an UPDATE query -

 

UPDATE your_table SET your_column = REPLACE(your_column, '.jpg', '.gif')

[Solarpitch]

Ah I see. Thanks guys. PFMaBiSmAd your one worked fine. Not sure why it didnt work with the STR_

[PFMaBiSmAd]

Because both the code thorpe and I posted showed using the mysql REPLACE() function in your query.

[trq]

Because both the code thorpe and I posted showed using the mysql REPLACE() function in your query.

 

I had actually posted STR_ but edited it. My bad.