Batch-Tool or phpmyadmin for mass Changings in image_table?

[hinzwiekunz]

Hi,

i have made e a new colomn called "image_license" in the image_table. Now I want to give all those pictures that filename begins with e.g. "mh_" a new value in the new colomn. How could I do it? With phpmyadmin or with a little php-script?

I dont can script something like that, but i could imagin that this stuff could explain what I want to do:

Code: [Select]

IF 4images_images_image_media_file="mh_*" {
INSERT INTO 4images_images VALUES (",",",",",",",",",",",",",",",",",1)
The last value "1" is the new column and in the standard table on "0". The other values shouldnt be touched.