$wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin

The difference is what is returned.

The WPDB query() method returns true for CREATE, ALTER, TRUNCATE and DROP queries, an integer of how many results for all other queries, or simply false if if there’s an error.

The WPDB get_results() method actually returns the entire result of the query (like you would get running the query in phpMyAdmin). You can return the result as an array or an object, depending on how you want to work with the results.

Related Posts:

  1. Differences between wpdb->get_results() and wpdb->query()
  2. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  3. wpdb get posts by taxonomy SQL
  4. Multipart/formatted MySQL query problem
  5. Custom $wpdb Query for Custom Post Type by Category
  6. Can’t pass table to $wpdb->prepare
  7. $wpdb->get_var not returning a result
  8. Most effective use of DB querys
  9. wpdb::prepare() isn’t working
  10. $wpdb doesn’t appear to work on page inside of a plugin
  11. Strange string in console from wpdb query
  12. Using $wpdb->update but confused on the WHERE in and SET
  13. Update slug (URL) of pending posts via phpMyAdmin
  14. What’s wrong with my $wpdb prepare?
  15. Make one query for adding entries to database
  16. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  17. Alter a specific query on WordPress
  18. wpdb->term_taxonomy count posts from both published and private posts?
  19. wpdb print all post meta
  20. Plugin will sort users by usermeta
  21. wpdb query problem to access previous 3 days posts
  22. How to write: $wpdb->update having WHERE NOT value pair in the array
  23. I can’t figure out what’s wrong with this statement. $wpdb->query update
  24. Use mysql_query instead of $wpdb query
  25. wpdb COALESCE won’t work
  26. Custom Query – Based on user input
  27. Custom SQL Query passing array to WHERE p.id
  28. Get posts from category with custom query
  29. Custom Query returns array, but I can’t see it’s elements
  30. Valid SQL query return empty
  31. mysql query – how to escape apostrophe?
  32. $wpdb->prepare affecting the query?
  33. prepare function sql safe method
  34. Updating with $qpdb->query() always returns 0 rows affected
  35. How to return count of custom post type posts with a specific custom field value via $wpdb?
  36. WordPress Mysql query and Duplicate
  37. How do I query for posts by custom meta and those that have been stickied?
  38. Help with Related Posts Function
  39. wpdb update multiple row?
  40. Formatting a date/time returned from a custom $wpdb query
  41. Improve performance of slow query
  42. How do I get specific readable results from this query and array results
  43. Display data from phpMyAdmin with WordPress
  44. implementing my wp_query using $wpdb class
  45. Exclude Posts from a Widget
  46. Fastest and most efficient SQL query to check if UID exists
  47. Use $wpdb->get_results with filter based on array
  48. $wpdb query for price in custom field value
  49. Display result from custom post meta query
  50. Wpdb empty result only if language is Russian
  51. Run an update query in a function
  52. How to fix this insert? Don’t work for me!
  53. Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
  54. Update vs Insert logic but the last key is always inserted?
  55. There is way to improve this query? wordpress get post data and some meta data
  56. $wpdb: how to use a query as a base for another query?
  57. Wpdb generates too many queries
  58. Custom Query for searching through custom fields
  59. Mysql query and odd results
  60. How to reference same column name but different table in custom db query
  61. Retrieving custom field array value through db query
  62. How to get one result using wpdb class?
  63. Delete query won’t run
  64. update $wpdb one query
  65. Get Terms by IDs with IDs order
  66. wpdb::prepare was called incorrectly
  67. Slow wp_enqueue_media()
  68. The use of including upgrade.php when building custom queries
  69. Mysql / WordPress killing my server with 80k users [closed]
  70. Query all posts and not repeat the same tag
  71. How many queries are normal to execute on a WP site?
  72. Insert static element only once in query archive
  73. How to run a mysql query when admin updates user role?
  74. Error when using setup_postdata()
  75. SQL query to select posts from multiple categories
  76. Iterating through $wpdb query without using get_results for large query results
  77. Select Query demand excesive resources [closed]
  78. Create Indexes for Slow Queries
  79. I want to create a filter for the query string is this possible?
  80. Exclude categories from the_category();
  81. How can i show all categories using wp query?
  82. Query returning same results even though the ID changes
  83. Why my query ‘REPLACE INTO…’ does not work?
  84. Restrict query to last day with posts
  85. Custom query object with Simple-Fields custom date field
  86. Customizing the_tags output?
  87. Querying with WP query using meta key price
  88. Re-sort get_posts query results
  89. create a link to a random post within the current category
  90. Pagination not working on custom post types with rewrite slug
  91. update_post_meta not working in template_redirect action
  92. Sort by postmeta on when searching
  93. Pulling an ACF into a query
  94. Using cron for multiple queries
  95. Proper way to trigger a MySQL query via link in a plugin
  96. Set posts per page for parent category and it’s all children
  97. Exclude sticky posts from query
  98. Rewrite Query_Var URL Parameter with Slug
  99. How to query different categories on index?
  100. Print data from wordpress sql query
error code: 523