Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I'm trying to get category list by specified first character.

For example if specified character query is "A", then just wanna list categories start with "A".

How is it possible?

share|improve this question
add comment

1 Answer

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 t2
    WHERE
        (t1.`term_id` = t2.`term_id`) /* Join tables on term_id */
        AND (t2.`taxonomy` = 'category') /* Make sure we get category taxonomy */
        /* Change parent (remove) according to your needs to dig deeper */
        AND (t2.`parent` = {$parent}) /* Remove to get all, not just top level */
        /* Remove the BINARY for case-insensitive comparison (both A and a) */
        AND (t1.`name` LIKE BINARY 'A%');
SQL
);

Follow the comments.

Regards.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.