URGENT HELP PLEASE: mySQL command for .... URGENT HELP PLEASE: mySQL command for ....
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

URGENT HELP PLEASE: mySQL command for ....

Started by JohannM, June 28, 2007, 05:39:38 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

JohannM

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.