I need some help / advise / guidance. i am a very basic user.
I would like to copy the contents of a certain field in one table to another within my Drupal database.
The structure of the two tables are different, but both tables share the same list of node IDs (nid).
One table is the node_revisions table, and the other is a content_field_description table.
By some mistake in the past, i had created the content_field_description field to contain the main body of the node content. now, as i try to clean things up, I want to move those content in the content_field_description into the node_revisions table. I only want to move the content in only one field between the two tables.
how do i do this? thanks in advance.