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. WP_Query with “post_title LIKE ‘something%'”?
  57. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  58. How to uniquely identify queries?
  59. Multipart/formatted MySQL query problem
  60. Use WP_Query with a custom SQL query
  61. How to query for a week using key => value WP_Query argument notation?
  62. meta_query on a date range using an array of values
  63. WPDB: how to get the value of a field in a custom database table
  64. How to detect custom query inside `posts_where` hook?
  65. Is temporarily overwriting $wp_query a bad idea?
  66. How to output different posts per page?
  67. Mysql query LIKE not working
  68. How to orderby meta_value_num with dollar ($) sign
  69. Query: offset post list, unless it’s a specific category
  70. Complex WP SQL Query
  71. Advanced SELECT query with condtional statements
  72. How to create database table, add data, update and delete using wpdb via plugins?
  73. Sorting events by descending date, and ascending time if multiple events on a date
  74. WP_Query with ‘rand’, but equal number of posts from the taxonomy terms given
  75. querying data via $wpdb and get_row
  76. I can’t figure out what’s wrong with this statement. $wpdb->query update
  77. Sort WordPress Posts Meta value by Week not Day
  78. 2 wordpress loops showing 1 post from same post type – how to avoid showing the same post?
  79. Conditional sorting with variable using WP Query
  80. Why Query is returning empty array?
  81. WP User Query with Custom Fields and Search Results
  82. meta_value timestamp older than now
  83. Clear Terms from Taxonomy for Specific Post IDs?
  84. How to filter query loop block with a search string from the query parameters
  85. Function to retrieve IDs of posts, cache results, and improve wp_query
  86. How to avoid filling up an array each time I run a WP_query?
  87. Query multiple post types, but different order for each
  88. What is the equivalent WP_Query of a SQL Query?
  89. Query against multiple locations within single custom post type post
  90. Fix wp_term_relationships slow query in get_posts
  91. How to get_comments() ordered by date and parent?
  92. Adding Category in WP_Query Not Working
  93. Merge two queries and remove duplicate
  94. Fetch only categorized posts
  95. Custom pagination (Title, date and teaser)
  96. Fire query on ajax post url page
  97. Wpdb generates too many queries
  98. Showing posts from 4 categories along with all latest posts
  99. how to add limit records in wordpress query
  100. WP_Query by meta key not returning any posts