change of filename in db

[Anon]

Hi all,
is it possible to change a file name (for example picture.JPG) in my database field 'productimage' to picture.jpg on hundreds of images stored already in the database instead of going through them one by one?
Hope someone can help me to save myself some time.
Thanx

[Anon]

I do belive there is a 'string to lower' function for mysql.. if thats the database you are using... the query would like like

UPDATE SET productimage=STRTOLOWER(productimage)