How To Get Some Data From WordPress Database Using WordPress $wpdb Query?

Just to clarify the get_var() method of $wpdb does work just fine in this context:

global $wpdb;
$helloworld_id = $wpdb->get_var("SELECT ID FROM wp_posts WHERE post_name="hello-world"");
echo $helloworld_id;

Actually it is more practical in this context, because a single variable is returned, which is what is actually wanted.

Related Posts:

  1. How to make an activities stream mixing posts and comments?
  2. How to correctly pass values to wpdb->prepare()?
  3. Is it possible to query from external database? [duplicate]
  4. List of ways to access WordPress database?
  5. Any way to use FETCH_KEY_PAIR with $wpdb?
  6. Include post_status check within $wpdb query
  7. wpdb get_results() returns only 2 rows
  8. Pagination with custom SQL query
  9. Return only Count from a wp_query request?
  10. Export wordpress table to excel
  11. What is an efficient way to query based on post_meta?
  12. SQL query equivalent to WP User Query
  13. how to retrieve specific product attribute value in an sql query?
  14. WP_Query Performance Issues with meta_query
  15. Should close $wpdb via $wpdb->close()
  16. Get the post permalink within the loop but without additional DB query
  17. Filter WordPress posts by between parameter
  18. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  19. Select from wp_post and multiple meta_value from wp_postmeta
  20. Order by custom table and multiplication
  21. $wpdb select date range of posts
  22. List of the years with posts presented
  23. Optional Meta Query
  24. Custom Query num_rows returns wrong amount
  25. Editing the default wordpress search
  26. Iterating through $wpdb query without using get_results for large query results
  27. WP Query related posts by tags
  28. Order by summing multiple values
  29. wp_Qwery works to slow
  30. Include data from custom table in WP_Query
  31. No results found from a $wpdb->get_results() query when trying to join more than one meta key query
  32. How to access custom WordPress database tables
  33. How to pass orderby params to $wpdb->prepare()?
  34. Make a SQL query with wpdb in WordPress
  35. WordPress query posts with multiple post_meta data
  36. Specify strict ‘order by’ in WordPress query
  37. How to set up hierarchical relationships without using plugins / meta query
  38. Does WordPress have something like Drupal’s DB API?
  39. Query where ANDing slug values not working
  40. Slow Query On Search
  41. How to SQL query posts IDs by categories AND authors?
  42. Disable (or limit) queries when certain content (or data) is not needed (or showed)
  43. Passing a SQL query to the WP Query
  44. Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
  45. How to get meta key list efficiently?
  46. How to get user avatar via WPDB
  47. Translating WP query into to SQL query
  48. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  49. What argument does my function need to echo get_results() query results
  50. WP_Query always returning the last custom post
  51. Optimising amount of calls to custom fields
  52. wpdb LIKE request shows all database data
  53. Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
  54. How much does $wpdb->prepare(), then $wpdb->query() VS straight $wpdb->query(), can slow down the load time of whole page
  55. how to use transient method?
  56. How to print the excuted sql right after its execution
  57. Whats the difference between post_limits and pre_get_posts?
  58. Make a WP Query search match exactly the search term
  59. Query WooCommerce orders where meta data does not exist
  60. Show only oldest post by author
  61. How to get the posts published in last two days using WP_Query?
  62. Dynamically Override Fancy Title – Part II
  63. Transient pagination not working properly
  64. Can not switch the queried post in pre_get_posts hook
  65. List the 5 most recent child pages
  66. SELECT * FROM $wpdb->posts WHERE ID > 160
  67. What is considered a default query for the request filter?
  68. $wpdb insert is not work
  69. How WordPress attaches its Featured Images with posts?
  70. How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
  71. wpdb custom post_type problem
  72. How to query a custom post type with a taxonomy filter but display post type archive page?
  73. Any possible way to make $wpdb->get_results() return anything else than array?
  74. Change query_posts to WP_Query in page but does not work
  75. Set conditional on template based on referring page slug
  76. Woocommerce – Changing the order of the upsell products [closed]
  77. How to get a query variable?
  78. date_query seems to be ignored by wp_query
  79. I can’t figure out what’s wrong with this statement. $wpdb->query update
  80. Sort WordPress Posts Meta value by Week not Day
  81. 2 wordpress loops showing 1 post from same post type – how to avoid showing the same post?
  82. Why Query is returning empty array?
  83. WP User Query with Custom Fields and Search Results
  84. meta_value timestamp older than now
  85. Clear Terms from Taxonomy for Specific Post IDs?
  86. How to filter query loop block with a search string from the query parameters
  87. Function to retrieve IDs of posts, cache results, and improve wp_query
  88. How to avoid filling up an array each time I run a WP_query?
  89. What is the equivalent WP_Query of a SQL Query?
  90. How to get_comments() ordered by date and parent?
  91. Merge two queries and remove duplicate
  92. Fetch only categorized posts
  93. Custom pagination (Title, date and teaser)
  94. Fire query on ajax post url page
  95. Wpdb generates too many queries
  96. Showing posts from 4 categories along with all latest posts
  97. how to add limit records in wordpress query
  98. WP_Query by meta key not returning any posts
  99. SQL query into to WP query
  100. Search results stuck on page 1