Posted By

web_la on 11/28/13


Tagged


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

fhenderson


Duplicate MySQL rows with slight changes


 / Published in: MySQL
 

For use with AWS S3 Wordpress pluign

  1. INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
  2. SELECT post_id, 'amazonS3_info' as meta_key, CONCAT('a:2:{s:6:"bucket";s:7:"bucketname";s:3:"key";s:', CHAR_LENGTH(meta_value) + 19,':"wp-content/uploads/', meta_value, '";}') FROM wp_postmeta WHERE meta_key = '_wp_attached_file'

Report this snippet  

You need to login to post a comment.