coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: JohannM on June 28, 2007, 05:39:38 PM

Title: URGENT HELP PLEASE: mySQL command for ....
Post by: JohannM on June 28, 2007, 05:39:38 PM
Hi

A week ago I skrewed up my picture table.

In specific , I have about 8500 specific pictures in the pictures table with e.g. filename: J099-0001.jpg (to J99-8500.jpg) with title J099-000 (to J099-8500).

I have keywords for each picture up to J099-2964.jpg.

I don't want to type all the keywords in all over.

Question: Is there a simple mySQL query that I can use to update the specific keywords belonging to the specific filename ?

Please help !

Thanx in advance.