I created a custom data field of type
text (alphanumeric) for use in a profile, but now realize it should have been a
textarea (primarily to support line/paragraph breaks). A number of the these text fields already have data in them. I have created a new textarea custom data field and need to get the data from the each text field into the textarea for the same contact. I'm thinking a can do it using SQL, something like this:
UPDATE table_name SET column1 = column2
However, poking around in phpMyAdmin, I can't find the relevant table.
Any help will be appreciated.
Wordpress 4.7.5 CiviCRM 4.7.17