I have a table with images, images
, in which one of these columns ( file_name
) has image names, jpg
other png
, what I need is to change, make UPDATE
all to the extension png
, that is, change any extension that has and put png
.
PS: There are file names that have points in addition to the extension, eg: "41sUhh.mGDDL. SY355 .jpg"