Instead of writing custom SQL, you should be able to just use the native get_category_by_slug() which will return a full category object to include the category ID.
Related Posts:
- How to create 450 categories in wp
- Custom Query to search through categories
- How Do I Merge Categories With phpMyAdmin
- Disallow categories from this MySQL query
- Accessing WordPress MySQL Database via Data Connection in Visual Studio 2010 using C#
- Change the category of all posts in it
- How to run select query of post with category and tags for API?
- How to get related tags based on a category?
- SQL to migrate post types to taxonomy
- Drop posts from categories in MySql
- WordPress Post # of # filtered by category slug
- Can Categories be used to hack a Multisite-like setup w/ a single MySql db?
- How to list all categories and their IDs using SQL query?
- How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
- How to add categories using mysql
- How do I merge WooCommerce categories with the same name?
- Bulk Change WordPress category Slug
- how to get postmeta info based on multiple categories?
- finding out the top 5 source ( source is a custom taxonomy ), in a given category
- How to make that all posts with a category belong also to another
- select posts from sql except posts from specific category
- How to create an automatic MultiColoumn MegaMenu with Categories WordPress
- Is There a Difference Between Taxonomies and Categories?
- List all subcategories from category
- How To Find Out WordPress Category Table in MYSQL?
- Add custom field to Category
- Get Category ID inside Category template
- Only one category per post
- WordPress Multisite – global categories
- Get the children of the parent category
- Get posts from sites in Multisite?
- WP REST API: filter by category 1 AND category 2
- How To Get Parent Category Slug of Current Post
- Display All Products by Category with WooCommerce
- What is the difference between a “tag” and a “category”?
- Is there an easy way to make a meta box have the tabs like the Categories meta box has?
- How to check if I’m on the last page of posts?
- Display posts from the same category using next/previous post link
- How would I get a taxonomy/category list inside a Gutenberg block?
- Can I set a default featured image for a category?
- Check if a post is in any child category of a parent category
- How to export and import taxonomies (category, tag and/or custom taxonomy) and their terms
- Force category choice before creating new post?
- Gutenberg editor add a custom category as wrapper for custom blocks
- WooCommerce: List All Categories
- How to get category and archive title?
- Get category ID from category slug (not working)
- How do I remove “Uncategorized” from posts with more than 1 category?
- Get rid of WordPress category, tag and author archives?
- Individual rss feed entry length for categories?
- How can I create a category landing page followed by pages of posts?
- Remove parent category from permalink? Basically only have the child category?
- Custom permalink structure leads to be 404 on pagination
- Retrieve Product category ‘NAME’ by product category ID – WooCommerce?
- Posts URL structure like site.com/category/the-post-title
- Can’t custom taxonomies have same terms (slugs) as categories?
- How to get permalinks with category base working with sub-categories
- How to remove the term “category” from category pagination?
- Using wp_category_checklist in a widget
- WP 3.9 TinyMCE no longer loads on category description editor
- On the category page, get the category object
- Get only the top level categories using get_categories() without foreach loop
- Get all categories and posts in those categories
- How to add featured image for category (without a plugin)?
- How to create a custom sort for WordPress categories
- How to display non-hierarchical taxonomy as terms with checkboxes?
- Category archive by year with permalink support /category/YYYY
- Best Way to Redirect Category to Page and Hide Category
- get_terms vs. get_categories: does it matter?
- What is a good robots.txt?
- Allow users to create their own feed from selected categories?
- Hook when category is added to post
- get_categories for custom post type with a specific custom taxonomy attached
- Add a URL prefix to permalinks of one category of posts only
- How do you add categories to custom post types in WordPress?
- Create a category list page
- Catch 404 after changing permalink structure from /%postname%/ to /%category%/%postname%/
- Woocommerce get category image full size
- exclude category from get_posts?
- How To Modify The Loop in archives.php To Have 11 Posts Per Page and CSS Styling
- How can I hide a category from Contributors in the edit/add new post screen?
- Order get_terms() By Custom Field
- WordPress Multiple Category Search
- Should category.php and The Loop be used if the query needs to be customizable?
- How do the ‘tag’ and ‘category’ (default) taxonomies do ‘save_post’ action?
- How to Change the Categories Order in the Admin Dashboard?
- Control term order on a per-post basis
- How to remove categories filter from wordpress admin?
- get all tags from category
- Could not insert term into the database
- How can I add the featured image functionality to a custom taxonomy?
- Activate Gutenberg in category-descriptions
- Filter by post category in Media Library
- Filtering categories in the permalink structure
- Share one taxonomy across multiple blogs in 3.0 [duplicate]
- 404 Error On Category and Tags Pages
- How to show subcategories in categories else show posts
- Allow duplicate permalink slugs for posts in different categories
- Exclude the category from the WordPress loop
- get_categories hierarchical order like wp_list_categories – with name, slug & link to edit cat