How to get a value-only flat array from $wpdb->get_results when selecting a single column, without foreach()?

Yes, there is.

If you want to retrieve just one column from the database table, i.e. all row values for that column, you can use wpdb::get_col().

$values = $wpdb->get_col( "SELECT field FROM {$wpdb->prefix}table" );
foreach ( $values as $value ) {
    // your code
}

Related Posts:

  1. $wpdb->get_row() only returns a single row?
  2. How to parse row results from $wpdb -> get_results
  3. what is the way to see the currently executing query in wordpress?
  4. Fetch array with $wpdb
  5. $wpdb->insert() and Values for Datetime Columns?
  6. $wpdb->last_error doesn’t show the query on error
  7. Theoretical Multi-Server WordPress Setup with Shared Users
  8. Change post status based on meta value
  9. Delete/replace img tags in post content for auto published posts [closed]
  10. What does wp_update_post() do that the $wpdb class does not?
  11. wpdb-> not adding prefix to custom table
  12. WordPress insert NOW() in TIMESTAMP column returns all zeros
  13. $wpdb prepare issue with mysql DATE_FORMAT
  14. How-To: wpdb Insert Record With Date
  15. How to pass NULL in where array for $wpdb->update
  16. Get random row from custom table
  17. store custom WP table names in a global variable
  18. I am not understandinhg $wpdb->prepare correctly
  19. How to save html and text in the database?
  20. XOR functionality for meta_query
  21. Using WPDB class
  22. How can I migrate mysql_fetch_array to $wbpdb?
  23. $wpdb->get_results returns empty but value exists
  24. WP Sql query multiple where clause
  25. What is _transient_random_seed for?
  26. wpdb get_results() and prepare when to use prepare?
  27. Foreach loop using $wpdb not results from rows
  28. Return XML of Post Metadata
  29. How to Instantiate wpdb Object in New File
  30. How do you build a wpdb query dynamically?
  31. Would this WPDB setup result in potential race conditions?
  32. How to update a row in a table in WordPress
  33. What’s the proper way to add users to my site in order to test things?
  34. Optimizing WordPress Queries – Removing Group By ID
  35. External DB Connection [closed]
  36. How to get entry by title by using wpdb
  37. Codex: Database Description: meaning of Cardinality
  38. Code only works every other time its run
  39. Can’t pass variable in wordpress wpdb->get_results
  40. WordPress db prepare
  41. How do I count columns on a custom WPDB query?
  42. how to get db values without using an loop with wpdb->get_results()
  43. Custom SQL query ORDER BY term_order
  44. Trouble inserting string containing quotations marks with wpdb in save_post hook
  45. How to left join meta in queries [closed]
  46. How to run wp_insert_post() & wpdb on the background?
  47. Trying to get variable from WP table and toggle its value
  48. Set MySQL variables in WPDB
  49. get_results query with accent
  50. How to prepare an array of values with $wpdb
  51. Is querying wpdb directly and skipping actions provided by WP’s core “wp_update_post” a good idea?
  52. $wpdb->insert() doesnt work anymore
  53. $wpdb query outputs php code instead of executing it
  54. wpdb query not working
  55. Where can I see MySQL hostname and port for wp-config.php
  56. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  57. Using “->” in a page to exceute $wpdb query gives error
  58. Unknown column ‘siteurl’ in ‘where clause’ WPDB outside
  59. Exclude specific terms from all queries using posts_where or something similar
  60. $wpdb->get_results not returning an array
  61. query a newly created table using $wpdb
  62. Get all sticky posts from one user through user ID
  63. WPDB Query Question with Category Only
  64. wpdb result arrray inside an array
  65. $wpdb->num_rows doesn’t work
  66. How can I change my meta_query to SQL wpdb query?
  67. How capturate wpdb exceptions?
  68. how to list all post that are in the custom taxonomy using $wpdb
  69. Limit left join
  70. “This message was added in version X” showing a later version than current one
  71. Get records from Formidable Table using $wpdb->get_col
  72. Prepare WPDB with meta key and meta value
  73. How to get row value from wpdb
  74. I am using wpdb but it not working perfectly.but if I dont use form data its work
  75. Escaping a WPDB Object in One Shot
  76. wont add form details to database or send me mail
  77. Create a stored procedure on plugin activation
  78. Missing argument 2 for wpdb::prepare() [duplicate]
  79. wpdb->update update the entire table instead of one row
  80. WPDP related functions look to work but they don’t
  81. Custom database query to validate data
  82. Save customizer default values to DB on theme activation
  83. Plugin with connection to database – Single function
  84. Alter the main search query to search posts by coauthor user name
  85. Protect custom form from SQL injection
  86. why nl2br() is adding an extra ?
  87. $wpdb->get_results in not an array
  88. How to make iteration on wpdb->update or query statement?
  89. How to add more custom fields in user meta table simultaneously
  90. wpdb->update error
  91. get unserialized array without using get_option()
  92. SQL Query to select post title & post ID from a particular category
  93. Create Table Failed Column Date DateType
  94. Using $wpdb to update current post
  95. Checking if meta_value exists for any user
  96. Can you create a new wpdb that connects to an SQL (not MYSQL) database? [duplicate]
  97. DBDelta: “table doesn’t exist” for a table that was just created
  98. query using wpdb in wordpress gets me no result
  99. $wpdb The query does not contain the correct number of placeholders
  100. $wpdb:insert, more arguements in $format array than in $data