List Categories By Specified First Character
global $wpdb; // In case it’s in a function… $parent = 0; // Change to dig deeper in tree $wpdb->query( <<<SQL SELECT t1.`term_id`, /* The ID */ t1.`name`, /* The name */ t1.`slug`, /* The slug */ t2.`parent`, /* The parent ID */ t2.`count` /* The item Count */ FROM {$wpdb->terms} AS t1, {$wpdb->term_taxonomy} AS … Read more