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

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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.

Print
Go Down Pages1
User actions

JohannM

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.
Print
Go Up Pages1
User actions