Not signed in (Sign In)

Vanilla 1.1.10 is a product of Lussumo. More Information: Documentation, Community Support.

General Support: Copy caption values to description values

Bottom of Page

1 to 5 of 5

  1.  
    • CommentAuthornaj0rt
    • CommentTimeApr 1st 2009
     
    Hi all, quick question...

    What would the sql command be to copy the 'caption' field values for every imaged in the database to the 'description' field ? Not sure how clear that question is so to explain, I have manually entered values in the 'caption' field for every image via plogger admin and I would like to copy those values into the 'description' field.

    Thanks in advance.
    •  
      CommentAuthorsidtheduck
    • CommentTimeApr 1st 2009
     
    naj0rt,

    Why did you want to change the captions from the descriptions? Are you wanting to move the data from the captions to the descriptions and clear out the captions at the same time, or do you want a copy of the same data in both fields? Just curious as it would change the SQL query slightly.
    • CommentAuthornaj0rt
    • CommentTimeApr 11th 2009
     
    *bumb*

    Does anyone know how to do this?
    •  
      CommentAuthorsidtheduck
    • CommentTimeApr 13th 2009
     
    naj0rt,

    sorry I didn't get back to you, I completely lost this thread amongst the others. The SQL query you would need to do is as follows (assuming your Plogger tables are prefixed by the default 'plogger_'):
    UPDATE `plogger_pictures` SET `description` = `caption`
    Thankful People: naj0rt
    • CommentAuthornaj0rt
    • CommentTimeApr 15th 2009
     
    Wow that was even easier than I expected, cheers.

1 to 5 of 5

  1.