Select column name dynamically mySQL Query

I guess one could argue that this is somewhat wordpress related, because you are trying to get_results() from $wpdb, but like @MarkKaplun said your problem is that you are using the SQL wrong. Below code is an example on how to do it correct:

$dr = $wpdb->get_results(
    $wpdb->prepare(
        "SELECT * FROM wp_shipping WHERE country = %s AND ID = %d",
        $country, $ids
    )
);

This is an example, you might have to fit it to your needs. For additional information you should take a closer look at the codex Class Reference: wpdb.

Related Posts:

  1. How to display SQL query that ran in 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. WordPress creating excessive joins on meta_query with search
  6. cron job to auto delete posts of a specific post type older than x days
  7. Are database queries created using WordPress filters protected from SQL injection?
  8. Get posts by category with pure SQL query
  9. Custom query to get terms from post ids
  10. Get the timout value of a saved transient?
  11. What’s wrong with my $wpdb prepare?
  12. How do I see the mysql query generated by get_posts( $args )?
  13. sql select query in wordpress ‘page’ [closed]
  14. problem with sql query in wordpress plugin
  15. Attempt to improve WP search, can someone check my SQL query?
  16. wpdb query problem to access previous 3 days posts
  17. I can’t figure out what’s wrong with this statement. $wpdb->query update
  18. Custom Query – Based on user input
  19. how to insert missing tags into the posts through mySQL?
  20. $wpdb->prepare affecting the query?
  21. WordPress SQL search, how to handle SQL Injection?
  22. exclude pingbacks from wordpress SQL query
  23. prepare function sql safe method
  24. WordPress SQL query to tag all posts containing a specific word on title
  25. How do I query for posts by custom meta and those that have been stickied?
  26. Change pure SQL database query to WordPress post query?
  27. Cannot get sql request from Query object?
  28. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  29. Display data from phpMyAdmin with WordPress
  30. SQL to Query the db and return all posts and it’s metas
  31. SQL query to delete users with multiple meta keys and comments
  32. Nested select statements not working
  33. Speed up search query that searches in post meta?
  34. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  35. Fastest and most efficient SQL query to check if UID exists
  36. How to make MySQL search queries with quotes
  37. How i make a custom sql query for Woocommerce
  38. $wpdb query for price in custom field value
  39. Run an update query in a function
  40. How to display a specific category using a custom Query in WordPress?
  41. Slow query when joining wp_posts with a lookup-table?
  42. Wpdb generates too many queries
  43. learn to run wpdb class
  44. SQL Query : how copy all tags of post into their post content in wordpress by sql query
  45. Where can I find the SQL to get the most used information by wordpress database?
  46. Custom Query for wp_posts using wp_postmeta
  47. 3 queries to update WordPress
  48. Get all image from single page using this query
  49. Add multiple value to a query variable in WordPress
  50. How to tune search argument in WP_Query to show only exactly the same results?
  51. How to get my loop to pull posts into three columns
  52. Can’t pass table to $wpdb->prepare
  53. Change SQL get_results to search for posts with custom term in custom taxonomy
  54. Date query year and month OR just year
  55. get post id using the $query_vars variable
  56. Is there a conditional tag for latest post or do i need a query?
  57. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  58. get_posts() loop returns the same the_title() for each post
  59. How select a specific query when setting offset?
  60. Temporarily storing main search result
  61. Help with MySQL to $WPDB query
  62. Order by summing multiple values
  63. wpdb->term_taxonomy count posts from both published and private posts?
  64. Group custom post listing in admin section
  65. List author’s posts with SQL
  66. Where is the query in wp-login.php
  67. Order posts by recent comments
  68. query if page has not child
  69. get_posts showing only 5 posts. (nopaging and posts_per_page -1 not working)
  70. Order by title – but now built in wordpress func, sort the_title
  71. pre saved posts query from db options table
  72. Order posts by date, but also give priority for a specific term
  73. Custom Query returns array, but I can’t see it’s elements
  74. How to insert Collate into WordPress search query?
  75. Combine “Exclude” Query in functions.php
  76. Optimize slow SQL query for multiple meta values
  77. Wrap/close ‘query’ for a first-letter ordered listing of posts
  78. wpdb query with dynamic column name?
  79. How do you display the number of a post in a query?
  80. How to return count of custom post type posts with a specific custom field value via $wpdb?
  81. How to rearrange a pool of posts joined using two queries?
  82. wpdb update multiple row?
  83. Can I include get_posts in this array?
  84. Custom query Custom-Post-Types creates error
  85. Formatting a date/time returned from a custom $wpdb query
  86. Rewrite rule for query params
  87. Hook into the Admin Dashboard and redirect users
  88. Job and Employee Performance Tracking with Product Safety
  89. Displaying data from custom table
  90. SEO friendly query vars
  91. Prevent versioning for .woff (font) files
  92. Orderby event date (if it exists) or post date (if it doesn’t) – how to reorder posts based on meta value OR date
  93. OR condition not working
  94. Query not returning child posts for any parent post ID
  95. Use $wpdb->get_results with filter based on array
  96. Add Hook for clearing transient when post is added
  97. Show links to child pages on both parent AND child pages
  98. Modify Global Posts Plugin
  99. How to reference same column name but different table in custom db query
  100. Retrieving custom field array value through db query