Answers.Body: <p>To find the correct table(s), you need to know the id of the custom field as well as the id of the custom group it's in.</p>
  
  <ul>
  <li>Go to <strong>Administer menu » Customize Data and Screens » Custom Fields</strong></li>
  <li>Click <strong>View and Edit Custom Fields</strong> next to the relevant custom field group.</li>
  <li>Look in the URL - it should read something like:
  <code>
  http://mysite.org/civicrm/admin/custom/group/field?reset=1&amp;action=browse&amp;gid=4
  </code></li>
  <li>Look for the number after <code>gid=</code> (in the example above, "4").</li>
  <li>In phpMyAdmin, look for the tables starting with <code>civicrm_value</code>.  Find the one that ends with the gid you identified above.</li>
  <li>You should be able to find your custom field data in there.  If your fields are very similarly named, you might also need to know the custom field ID.  In that case, click <strong>Edit Field</strong> and note the <code>id</code> in the URL.  The custom field you're looking for ends with that number.</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-23T21:42:36.807Z
Answers.LastActivityDate: 2017-05-23T21:42:36.807Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I created a custom data field of type <code>text (alphanumeric)</code> for use in a profile, but now realize it should have been a <code>textarea</code> (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:</p>
  
  <pre><code>UPDATE table_name 
  SET column1 = column2
  </code></pre>
  
  <p>However, poking around in phpMyAdmin, I can't find the relevant table.</p>
  
  <p>Any help will be appreciated.</p>
  
  <p>Wordpress 4.7.5 CiviCRM 4.7.17</p>
  
Tags: <wordpress><custom-fields><mysql><textarea>
Title: how to copy data from one custom field to another (text to textarea)
ThreadText: # how to copy data from one custom field to another (text to textarea)
  
  (Asked by: username_0 on 2017-05-23)
  
  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
  
  **Tags:** wordpress, custom-fields, mysql, textarea
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-05-23. Score: 2 | Accepted answer
  
  To find the correct table(s), you need to know the id of the custom field as well as the id of the custom group it's in.
  
  * Go to **Administer menu » Customize Data and Screens » Custom Fields**
  * Click **View and Edit Custom Fields** next to the relevant custom field group.
  * Look in the URL - it should read something like:
    `http://mysite.org/civicrm/admin/custom/group/field?reset=1&action=browse&gid=4`
  * Look for the number after `gid=` (in the example above, "4").
  * In phpMyAdmin, look for the tables starting with `civicrm_value`. Find the one that ends with the gid you identified above.
  * You should be able to find your custom field data in there. If your fields are very similarly named, you might also need to know the custom field ID. In that case, click **Edit Field** and note the `id` in the URL. The custom field you're looking for ends with that number.
  
  
  ---
  
  