WordPress: Using the category slug get the category ID using mysql query

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:

  1. How to create 450 categories in wp
  2. Custom Query to search through categories
  3. How Do I Merge Categories With phpMyAdmin
  4. Disallow categories from this MySQL query
  5. Accessing WordPress MySQL Database via Data Connection in Visual Studio 2010 using C#
  6. Change the category of all posts in it
  7. How to run select query of post with category and tags for API?
  8. How to get related tags based on a category?
  9. SQL to migrate post types to taxonomy
  10. Drop posts from categories in MySql
  11. WordPress Post # of # filtered by category slug
  12. Can Categories be used to hack a Multisite-like setup w/ a single MySql db?
  13. How to list all categories and their IDs using SQL query?
  14. How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
  15. How to add categories using mysql
  16. How do I merge WooCommerce categories with the same name?
  17. Bulk Change WordPress category Slug
  18. how to get postmeta info based on multiple categories?
  19. finding out the top 5 source ( source is a custom taxonomy ), in a given category
  20. How to make that all posts with a category belong also to another
  21. Control term order on a per-post basis
  22. Display all posts from all categories with pagination
  23. Changing Top Level Items into Radio Buttons in the Categories Meta Box?
  24. How to create a widgetized sidebar for every category dynamically?
  25. Display the deepest child category from Category X (in loop)
  26. When using get_categories or similar, is it possible to filter results that contain certain Tags as well?
  27. WooCommerce – Display product child categories from specific parent
  28. Select category in custom query
  29. Removed slug from CPT, now How/where do I hook the filter to the taxonomy term archive pages link?
  30. Show list of categories even if they have no posts
  31. How to control template resolution if both Author and Category filter in place?
  32. Resolved – category-slug.php not working after wordpress migration
  33. How to retain the values from dropdown category lists after wrong form submission?
  34. Format Brand value in Category view [closed]
  35. Get multidimensional array that reflects category hierarchy
  36. Single_cat_title() print the title before text
  37. Sort posts by post_type in category.php template
  38. Add Post Screen Keep Category structure
  39. Possible to make a subdirectory that loops through a single category?
  40. editing fonts of category links from the_category() funtion
  41. Force a user’s posts category
  42. Automatically set default password to all posts in a specific category
  43. Style wp_list_categories
  44. Checking for two categories in query_posts
  45. get_the_categories filter returns an empty array
  46. Warn me about ‘uncategorized’ posts
  47. Categories showing page not found
  48. Why category.php throw 404 in wordpress while calling paginate_links()?
  49. Show category to visitors in different name or different language without changing basic category
  50. How to get latest posts from each category in regular order
  51. Pagination for ajax category filter
  52. Get posts from specific taxonomy term
  53. limit a list of tags to one category [closed]
  54. How many categories can WordPress handle before performance suffers?
  55. WordPress Drop down category as array for using in page builder
  56. Get sort order of product categories
  57. how to wordpress When I click on the category link, subcategories appear
  58. Show posts in “image” format when viewed in category page, but with comments in blog
  59. How to pull a list of posts in a category while exluding posts in subcategories of the category
  60. How to change the order of the subcategory and category in a post?
  61. Properly setting up a feed
  62. Display posts of certain categories to specific user roles
  63. Display Related Posts by “Category” “by Author”
  64. Change post title if post has specific category
  65. How to schedule categories?
  66. Template for product-category page [closed]
  67. How set all posts in wordpress in one category
  68. custom query for both category and pages using global $wpdb;
  69. url for posts for a date within a category
  70. Autolinking keywords in text with tags
  71. WP E-Commerce creating categories programmaticaly [closed]
  72. query_post problem
  73. Get a list of all links on a page?
  74. Load the last post of a category
  75. create function to call category name and slug
  76. Disable Category Taxonomy
  77. How to make product image inherit from category image
  78. Is this process OK to replace URL structure?
  79. Is it possible to set up blog categories without changing permalink structure
  80. How to display categories image in loop homepage WordPress
  81. how to give different template to each subcategory from same parent category?
  82. No hierarchy in wp_list_categories with child of and depth
  83. How to check a category checkbox using JavaScript
  84. Need help to structure our a complex hierarchy
  85. global categories – Share specific categories in wordpress multisite
  86. WordPress update 4.7 – the 70.000+ news posts became “Uncategorized”
  87. How to auto update post title and slug with category name when post status is updated
  88. Choosing different templates for categories
  89. Problem with wp_list_categories
  90. hierarchical taxonomy in permalinks? using same slug
  91. Display one post on category.php: Wrong featured image
  92. WordPress Numeric Pagination with Query String [duplicate]
  93. Changing Permalinks for Category Pages Only
  94. Taxonomy for custom post type not found
  95. How can I get this code to only output one link?
  96. Sorting Woocommerce products by category and attributes
  97. How to get Woocomerce categories count
  98. show posts from some category and sort by advance custom field
  99. Function to reference post meta in place of category Woocommerce
  100. Category Redirection Problem