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

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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