Could not find a DB thread about how to change image names in the mysql database

I'd like to know if someone could show me how to use the SQL Query Executor to change references to the image files... like for instance say I'd like to go change a product picture for ALL products that use this image "/images/AEM.jpg" to "/images/aem.jpg" ?

I think it's a fairly simple query to run, but I'm unsure how to limit the query's changes to the correct fields in my database. I don't just want the query to run willy nilly about the database trashing every entry of AEM.jpg . lol..

:lamo:

Thanks in advance!!

First of all, the images/ folder is the default, so the database stores locations of all images in that folder simply as filename.ext

You could run this query from the Install SQL Patches tool:

UPDATE products SET products_image = 'aem.jpg' WHERE products_image = 'AEM.jpg';

Note that default database installations most commonly use a collation of latin or latin_swedish_ci, which means comparisons of non-binary strings (which the products_image field is) will be case-insensitive. So the query suggested above is actually going to change all instances of aem.jpg regardless of case: eg aem.jpg, aEm.JPG, AEM.jpg etc.