Why won’t this wpdb get_results query return results?

When the query was done using ~ (tilda) quotes around columns in the SQL instead of the ‘ it worked. It has something to do with the collation of my tables in MySQL, I believe.

Related Posts:

  1. How to return number of found rows from SELECT query
  2. Can i use php sql functions instead of $wpdb?
  3. $wpdb->delete column values IN ARRAY()?
  4. Custom query to get post names beginning with a digit
  5. WordPress get pagination on wpdb get_results
  6. Ajax $wpdb not returning table data
  7. Converting MYSQL to WordPress $WPDB
  8. Why is variable not working on custom sql query using wpdb?
  9. Show MySQL errors that occur when I excute $wpdb->insert()
  10. Can’t get wp_insert_post to work
  11. WSoD being caused by this piece of code
  12. I want to select the from values from database in WordPress? [closed]
  13. Update results, Before deleting the related category [closed]
  14. wp query foreach deleting record returning only first or last item
  15. Database query works fine outside WordPress
  16. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  17. $wpdb->insert() does not Insert record in a table
  18. Help with a $wpdb MySQL Query
  19. Custom array from a query only write the last row of the query
  20. $wpdb returns duplicate posts
  21. Mixing variables into an array when inserting values
  22. Use $wpdb or other PHP script method to find/replace in WP database
  23. How can I add a new row in a separate database when someone registers via WordPress?
  24. Basic wpdb update question
  25. I can’t update my data through $wpdb
  26. Output: “Array”
  27. How to use mysql LIKE with wpdb?
  28. How do I prepare strings for insertions as values into a MySQL table?
  29. How to use AJAX in WordPress in MYSQL query?
  30. form $_post action value gets truncated after it passes through two forms
  31. WPDB secure custom form
  32. Add row to custom database Table and delete all rows older than 1 day
  33. select a single val though a table in wordpress
  34. populate select options from extra mysql table data
  35. Query the links Database
  36. MySQL Query Returns Array () In Shortcode
  37. Passing in MySQL prepare statement parameter separately throwing error
  38. Convert a column of a table containing an Array as response in HTML
  39. Database SQL query error
  40. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  41. Conditional formatting on data fetched from MYSQL
  42. What is the correct way to search 3 custom fields only in WordPress?
  43. Using wpdb to connect to a different database is not working
  44. Rewrite SQL query as a prepared statement and use in foreach loop
  45. Advanced WordPress SQL Query
  46. MySQL query in WordPress with AJAX
  47. Passed variable gets undefined variable error on insert on next page
  48. MySQL queries in WordPress
  49. Using the same shortcode to show any table from the database
  50. MySQL database migration to WordPress
  51. Error resetting database index using ALTER TABLE in $wpdb->query
  52. Putting form result in my database
  53. How can I update a value of a field depending on outside source?
  54. wpdb::prepare was called incorrectly
  55. How to get the list of WooCommerce product image of a certain category from database?
  56. Changing user_nicename
  57. WordPress will not operate correctly
  58. tag search using WP_Query
  59. Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  60. if statement on database query
  61. Is the regular ajax request method safe or I should use admin-ajax.php?
  62. Sortable admin column for one meta key with three possible meta values
  63. WordPress Ajax Custom Query – High CPU LOAD
  64. AJAX in WordPress, sending coords data to MySQL and show after into map
  65. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  66. Styling images coming from another blog
  67. How to convert objects into arrays
  68. Is there a way to get 3+ dimensional array from a single MySql command
  69. How to insert a single row to WP database table?
  70. mysql query from wordpress page using custom table
  71. Importing Geo data into wordpress database
  72. PHP Fatal error: Uncaught mysqli_sql_exception: Table doesn’t exist in wordpress/wp-includes/wp-db.php
  73. How to check if a meta value has already been assigned to any user?
  74. Force Users To Relogin
  75. how to get serialized post meta
  76. A $_POST should occur when submit form but is not?
  77. Pull MySQL data from multiple tables and merge into 1 PHP array
  78. Using CFDB7 vs Custom MySQL Database [closed]
  79. WPDB – Read and write value from / to database
  80. Using Ajax to submit a form, and run a SQL Select query based on user input from the form
  81. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  82. WordPress low speed after migrating to new host
  83. AWS Lightsail WordPress – connect to database on instance using mysqli
  84. call to undefined function mysql_connect
  85. How to edit content in WordPress and the Polylang – plugin? – with demosite
  86. Looping through custom data in a custom table to display all items in a post
  87. Insert data from form to database
  88. Prepared DB Query from _POST array
  89. Conditional statement within WP SQL query
  90. Run insert if no entry otherwise run update with ajax
  91. WordPress upload images not displaying
  92. two wordpress sites, two themes, one database, same content
  93. how to check for wordpress Query errors
  94. Custom query_posts() parameter
  95. Query Concatenation
  96. Display total count of products in orders of a specific order status
  97. WordPress Query -> Ajax Query
  98. how to display tables via ajax
  99. WordPress / PHP: Check if column has value and then check if value in array
  100. Can’t insert into a database wordpress