Looking for MYSQL Query to change image extension from .JPG to .jpg

[JDMEngineLand]

MYSQL Query...to change image extension from .JPG to .jpg


need a mysql query to change all file extensions from .JPG to .jpg....

[gjh42]

Are you trying to change the actual image filename extensions? You can't do that with MySQL; that can only affect info stored in the database.

[JDMEngineLand]

no the files are already changed, but the file extension WITHIN the Database, need to be changed to all lower case just the extension

so basically i would need a query to just look up product image, and change all extensions to .jpg from .JPG

because right now since all the files have .jpg and DB is looking for .JPG.. and not showing any images.


http://www.jdmengineland.com check out the product listing it doesnt show most images.

[schoolboy]

BACKUP DBASE FIRST!!!!!

UPDATE `zen_products` SET `products_image` = REPLACE(`products_image`, "JPG", "jpg") WHERE RIGHT(`products_image`, 3) = "JPG";

Naturally, if your dbase does NOT use prefixes...

UPDATE `products` SET `products_image` = REPLACE(`products_image`, "JPG", "jpg") WHERE RIGHT(`products_image`, 3) = "JPG";

[JDMEngineLand]

thank you, much appreciated.