Key-value storage for user metadata. Stores capabilities, preferences, and custom user data.<\/p>
umeta_id<\/code><\/td>bigint(20) unsigned<\/td>NO<\/td>auto_increment<\/td>Unique identifier for the meta entry<\/td><\/tr>user_id<\/code><\/td>bigint(20) unsigned<\/td>NO<\/td>0<\/td>Associated user ID (FK \u2192 wp_users.ID)<\/td><\/tr>meta_key<\/code><\/td>varchar(255)<\/td>YES<\/td>NULL<\/td>Meta key name<\/td><\/tr>meta_value<\/code><\/td>longtext<\/td>YES<\/td>NULL<\/td>Meta value (can be serialized)<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>umeta_id<\/td>Yes<\/td>Primary key<\/td><\/tr>user_id<\/code><\/td>user_id<\/td>No<\/td>All meta for a user<\/td><\/tr>meta_key<\/code><\/td>meta_key(191)<\/td>No<\/td>Lookup by key name<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>user_id<\/code> \u2192 wp_users.ID<\/code> (the user this meta belongs to)<\/li><\/ul>Core Meta Keys<\/h2>Authentication & Capabilities<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>wp_capabilities<\/code><\/td>Serialized array of role(s) \u2192 true<\/td><\/tr>wp_user_level<\/code><\/td>Deprecated numeric user level (0-10)<\/td><\/tr>session_tokens<\/code><\/td>Active login sessions<\/td><\/tr><\/tbody><\/table><\/figure>Profile Information<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_id<\/code><\/td>bigint(20) unsigned<\/td>NO<\/td>0<\/td>Associated user ID (FK \u2192 wp_users.ID)<\/td><\/tr>meta_key<\/code><\/td>varchar(255)<\/td>YES<\/td>NULL<\/td>Meta key name<\/td><\/tr>meta_value<\/code><\/td>longtext<\/td>YES<\/td>NULL<\/td>Meta value (can be serialized)<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>umeta_id<\/td>Yes<\/td>Primary key<\/td><\/tr>user_id<\/code><\/td>user_id<\/td>No<\/td>All meta for a user<\/td><\/tr>meta_key<\/code><\/td>meta_key(191)<\/td>No<\/td>Lookup by key name<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>user_id<\/code> \u2192 wp_users.ID<\/code> (the user this meta belongs to)<\/li><\/ul>Core Meta Keys<\/h2>Authentication & Capabilities<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>wp_capabilities<\/code><\/td>Serialized array of role(s) \u2192 true<\/td><\/tr>wp_user_level<\/code><\/td>Deprecated numeric user level (0-10)<\/td><\/tr>session_tokens<\/code><\/td>Active login sessions<\/td><\/tr><\/tbody><\/table><\/figure>Profile Information<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
meta_key<\/code><\/td>varchar(255)<\/td>YES<\/td>NULL<\/td>Meta key name<\/td><\/tr>meta_value<\/code><\/td>longtext<\/td>YES<\/td>NULL<\/td>Meta value (can be serialized)<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>umeta_id<\/td>Yes<\/td>Primary key<\/td><\/tr>user_id<\/code><\/td>user_id<\/td>No<\/td>All meta for a user<\/td><\/tr>meta_key<\/code><\/td>meta_key(191)<\/td>No<\/td>Lookup by key name<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>user_id<\/code> \u2192 wp_users.ID<\/code> (the user this meta belongs to)<\/li><\/ul>Core Meta Keys<\/h2>Authentication & Capabilities<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>wp_capabilities<\/code><\/td>Serialized array of role(s) \u2192 true<\/td><\/tr>wp_user_level<\/code><\/td>Deprecated numeric user level (0-10)<\/td><\/tr>session_tokens<\/code><\/td>Active login sessions<\/td><\/tr><\/tbody><\/table><\/figure>Profile Information<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
meta_value<\/code><\/td>longtext<\/td>YES<\/td>NULL<\/td>Meta value (can be serialized)<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>umeta_id<\/td>Yes<\/td>Primary key<\/td><\/tr>user_id<\/code><\/td>user_id<\/td>No<\/td>All meta for a user<\/td><\/tr>meta_key<\/code><\/td>meta_key(191)<\/td>No<\/td>Lookup by key name<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>user_id<\/code> \u2192 wp_users.ID<\/code> (the user this meta belongs to)<\/li><\/ul>Core Meta Keys<\/h2>Authentication & Capabilities<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>wp_capabilities<\/code><\/td>Serialized array of role(s) \u2192 true<\/td><\/tr>wp_user_level<\/code><\/td>Deprecated numeric user level (0-10)<\/td><\/tr>session_tokens<\/code><\/td>Active login sessions<\/td><\/tr><\/tbody><\/table><\/figure>Profile Information<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
PRIMARY<\/code><\/td>umeta_id<\/td>Yes<\/td>Primary key<\/td><\/tr>user_id<\/code><\/td>user_id<\/td>No<\/td>All meta for a user<\/td><\/tr>meta_key<\/code><\/td>meta_key(191)<\/td>No<\/td>Lookup by key name<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>user_id<\/code> \u2192 wp_users.ID<\/code> (the user this meta belongs to)<\/li><\/ul>Core Meta Keys<\/h2>Authentication & Capabilities<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>wp_capabilities<\/code><\/td>Serialized array of role(s) \u2192 true<\/td><\/tr>wp_user_level<\/code><\/td>Deprecated numeric user level (0-10)<\/td><\/tr>session_tokens<\/code><\/td>Active login sessions<\/td><\/tr><\/tbody><\/table><\/figure>Profile Information<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_id<\/code><\/td>user_id<\/td>No<\/td>All meta for a user<\/td><\/tr>meta_key<\/code><\/td>meta_key(191)<\/td>No<\/td>Lookup by key name<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>user_id<\/code> \u2192 wp_users.ID<\/code> (the user this meta belongs to)<\/li><\/ul>Core Meta Keys<\/h2>Authentication & Capabilities<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>wp_capabilities<\/code><\/td>Serialized array of role(s) \u2192 true<\/td><\/tr>wp_user_level<\/code><\/td>Deprecated numeric user level (0-10)<\/td><\/tr>session_tokens<\/code><\/td>Active login sessions<\/td><\/tr><\/tbody><\/table><\/figure>Profile Information<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
meta_key<\/code><\/td>meta_key(191)<\/td>No<\/td>Lookup by key name<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>user_id<\/code> \u2192 wp_users.ID<\/code> (the user this meta belongs to)<\/li><\/ul>Core Meta Keys<\/h2>Authentication & Capabilities<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>wp_capabilities<\/code><\/td>Serialized array of role(s) \u2192 true<\/td><\/tr>wp_user_level<\/code><\/td>Deprecated numeric user level (0-10)<\/td><\/tr>session_tokens<\/code><\/td>Active login sessions<\/td><\/tr><\/tbody><\/table><\/figure>Profile Information<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_id<\/code> \u2192 wp_users.ID<\/code> (the user this meta belongs to)<\/li><\/ul>Core Meta Keys<\/h2>Authentication & Capabilities<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>wp_capabilities<\/code><\/td>Serialized array of role(s) \u2192 true<\/td><\/tr>wp_user_level<\/code><\/td>Deprecated numeric user level (0-10)<\/td><\/tr>session_tokens<\/code><\/td>Active login sessions<\/td><\/tr><\/tbody><\/table><\/figure>Profile Information<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_users.ID<\/code> (the user this meta belongs to)<\/li><\/ul>Core Meta Keys<\/h2>Authentication & Capabilities<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>wp_capabilities<\/code><\/td>Serialized array of role(s) \u2192 true<\/td><\/tr>wp_user_level<\/code><\/td>Deprecated numeric user level (0-10)<\/td><\/tr>session_tokens<\/code><\/td>Active login sessions<\/td><\/tr><\/tbody><\/table><\/figure>Profile Information<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_capabilities<\/code><\/td>Serialized array of role(s) \u2192 true<\/td><\/tr>wp_user_level<\/code><\/td>Deprecated numeric user level (0-10)<\/td><\/tr>session_tokens<\/code><\/td>Active login sessions<\/td><\/tr><\/tbody><\/table><\/figure>Profile Information<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_user_level<\/code><\/td>Deprecated numeric user level (0-10)<\/td><\/tr>session_tokens<\/code><\/td>Active login sessions<\/td><\/tr><\/tbody><\/table><\/figure>Profile Information<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
session_tokens<\/code><\/td>Active login sessions<\/td><\/tr><\/tbody><\/table><\/figure>Profile Information<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
nickname<\/code><\/td>User’s nickname<\/td><\/tr>first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
first_name<\/code><\/td>First name<\/td><\/tr>last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
last_name<\/code><\/td>Last name<\/td><\/tr>description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
description<\/code><\/td>Biographical info<\/td><\/tr><\/tbody><\/table><\/figure>Preferences<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
admin_color<\/code><\/td>Admin color scheme<\/td><\/tr>use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
use_ssl<\/code><\/td>Force SSL on admin<\/td><\/tr>show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
show_admin_bar_front<\/code><\/td>Show admin bar on frontend<\/td><\/tr>locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
locale<\/code><\/td>User-specific locale<\/td><\/tr>rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
rich_editing<\/code><\/td>Use visual editor<\/td><\/tr>syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
syntax_highlighting<\/code><\/td>Code syntax highlighting<\/td><\/tr>comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
comment_shortcuts<\/code><\/td>Keyboard shortcuts for comments<\/td><\/tr><\/tbody><\/table><\/figure>Dashboard & Admin<\/h3>Key<\/th>Description<\/th><\/tr><\/thead>dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
dismissed_wp_pointers<\/code><\/td>Dismissed admin pointers<\/td><\/tr>wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_dashboard_quick_press_last_post_id<\/code><\/td>Quick Draft post ID<\/td><\/tr>community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
community-events-location<\/code><\/td>Dashboard events location<\/td><\/tr>closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
closedpostboxes_*<\/code><\/td>Collapsed metaboxes<\/td><\/tr>metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
metaboxhidden_*<\/code><\/td>Hidden metaboxes<\/td><\/tr>screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
screen_layout_*<\/code><\/td>Screen column layout<\/td><\/tr><\/tbody><\/table><\/figure>Capabilities Format<\/h2>php<\/span><\/use><\/svg><\/button><\/div>\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\/\/ wp_capabilities value (serialized)\na:1:{s:13:"administrator";b:1;}\n\n\/\/ Decoded\n['administrator' => true]<\/code><\/pre><\/div>Common Queries<\/h2>Get all meta for a user<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SELECT meta_key, meta_value \nFROM wp_usermeta \nWHERE user_id = 1;<\/code><\/pre><\/div>Get specific meta value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SELECT meta_value \nFROM wp_usermeta \nWHERE user_id = 1 \n AND meta_key = 'first_name';<\/code><\/pre><\/div>Get all administrators<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SELECT u.* \nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities' \n AND um.meta_value LIKE '%administrator%';<\/code><\/pre><\/div>Get users with specific meta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SELECT u.*, um.meta_value as custom_field\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'my_custom_field';<\/code><\/pre><\/div>Delete orphaned usermeta<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
DELETE um FROM wp_usermeta um\nLEFT JOIN wp_users u ON um.user_id = u.ID\nWHERE u.ID IS NULL;<\/code><\/pre><\/div>Count users by role<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SELECT \n CASE \n WHEN meta_value LIKE '%administrator%' THEN 'administrator'\n WHEN meta_value LIKE '%editor%' THEN 'editor'\n WHEN meta_value LIKE '%author%' THEN 'author'\n WHEN meta_value LIKE '%contributor%' THEN 'contributor'\n WHEN meta_value LIKE '%subscriber%' THEN 'subscriber'\n ELSE 'other'\n END as role,\n COUNT(*) as count\nFROM wp_usermeta\nWHERE meta_key = 'wp_capabilities'\nGROUP BY role;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
get_user_meta( $user_id, $key, $single )<\/code> – Get meta value(s)<\/li>add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
add_user_meta( $user_id, $key, $value, $unique )<\/code> – Add meta<\/li>update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
update_user_meta( $user_id, $key, $value )<\/code> – Update meta<\/li>delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
delete_user_meta( $user_id, $key, $value )<\/code> – Delete meta<\/li>get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
get_user_option( $option, $user_id )<\/code> – Get user option<\/li>update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
update_user_option( $user_id, $option, $value )<\/code> – Update user option<\/li><\/ul>Multisite Notes<\/h2>In multisite, capabilities use the blog prefix:<\/p>wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
In multisite, capabilities use the blog prefix:<\/p>
wp_capabilities<\/code> \u2192 single site or main site<\/li>wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_2_capabilities<\/code> \u2192 site ID 2<\/li>wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_3_capabilities<\/code> \u2192 site ID 3<\/li><\/ul>The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
The {$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
{$prefix}_user_level<\/code> follows the same pattern.<\/p>Performance Notes<\/h2>Session tokens can grow large with many active sessions<\/li>Stale session data should be periodically cleaned<\/li>Use get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
get_user_meta()<\/code> with $single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
$single = true<\/code> when expecting one value<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry user_id…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5593","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions"}],"predecessor-version":[{"id":8931,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5593\/revisions\/8931"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5593"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5593"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5593"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}