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

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

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

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.

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.

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";

thank you, much appreciated.