MySQL Query: How do I take off what a field has and add it to another one?

  • After I found which ones correspond with a column (meta_key “address”) of the table wp_postmeta..

    SELECT * FROM wp_posts
LEFT JOIN wp_postmeta
ON wp_posts.ID = wp_postmeta.post_id
WHERE wp_postmeta.meta_key = 'address'

    I want to take(and leave nothing there) from the column “meta_value” everything that is registered to and add it to the column “post_content” that is on the table “wp_post”.

    In every corresponding “post_content” are many thing registered and I don’t want to lose them, I want whatever it takes from “meta_value” to just add it at the end of every input that is in every “post_content”. Is this possible?

Viewing 1 replies (of 1 total)

  • This is what I would do:

    Take a backup of the database.
    Run you above query, extract the results into a CSV file.
    Load the CSV file into a spreadsheet.
    Workout various UPDATE statements for your different tables, one per row.
    Transfer the statements into a text editor, thence run in your SQL browser.

Viewing 1 replies (of 1 total)
  • The topic ‘MySQL Query: How do I take off what a field has and add it to another one?’ is closed to new replies.