Title: SQL Database
Last modified: August 21, 2016

---

# SQL Database

 *  Resolved [timmelody](https://wordpress.org/support/users/timmelody/)
 * (@timmelody)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sql-database-1/)
 * Hi, do user’s user group data get stored in the/a Worpress MySQL database – i.
   e. if I wanted to pull that info into a CRM? And if so, where? Thanks for any
   help!
 * [https://wordpress.org/plugins/user-groups/](https://wordpress.org/plugins/user-groups/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [juggledad](https://wordpress.org/support/users/juggledad/)
 * (@juggledad)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/sql-database-1/#post-4658622)
 * Yes the data is stored in the database in teh wp_terms, wp_terms_relationship
   and wp_terms_taxonomy tables
 *  [donaldng](https://wordpress.org/support/users/donaldng/)
 * (@donaldng)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/sql-database-1/#post-4658626)
 * **Following function may help**
 * // Get group name by author id (by DN 20150108)
    function get_groupname_by_author_id(
   $aid) { global $wpdb; $term_ids = $wpdb->get_results( $wpdb->prepare( “ SELECT
   wp_term_taxonomy.term_id FROM wp_term_taxonomy INNER JOIN wp_term_relationships
   USING (term_taxonomy_id) WHERE wp_term_taxonomy.taxonomy = ‘user-group’ AND wp_term_relationships.
   object_id = %d “, $aid) );
 *  if($term_ids) {
    $termid= $term_ids[0]->term_id; // echo ” termid: “. $termid;}
   else { $termid=””; } $term = get_term_by( ‘id’, absint($termid), ‘user-group’);
   $groupname = $term->name; if ($groupname) { return $groupname; } else { $groupname
   = “”; return $groupname; } }
 *  [jesperb](https://wordpress.org/support/users/jesperb/)
 * (@jesperb)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/sql-database-1/#post-4658628)
 * `wp_get_object_terms(2, 'user-group');`

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘SQL Database’ is closed to new replies.

 * ![](https://ps.w.org/user-groups/assets/icon-256x256.jpg?rev=1179282)
 * [User Groups](https://wordpress.org/plugins/user-groups/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/user-groups/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/user-groups/)
 * [Active Topics](https://wordpress.org/support/plugin/user-groups/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/user-groups/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/user-groups/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * 3 replies
 * 4 participants
 * Last reply from: [jesperb](https://wordpress.org/support/users/jesperb/)
 * Last activity: [11 years, 3 months ago](https://wordpress.org/support/topic/sql-database-1/#post-4658628)
 * Status: resolved