Move photos to a different category using a mySQL commend

[criscokid]

I've upload a load of photos to the incorrect category - 692 instead 693. The easiest way to move all of these photo would be to use a mySQL command to replace all instances of 692 in the cat field and with 693.

What would the mySQL command I'd use to do this?

[Michael P]

You can't without moving the files themselves, too; they are stored in a directory under the cateogry number. You would be better off using the Bulk Actions section to move a group of images.