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. Fatal error: Call to undefined function mysql_connect()
  55. the_date() not working
  56. How to make WordPress plugin check for database changes and then do something?
  57. Print out WordPress user ID – two sites with same code but different output
  58. WPDB: how to get the value of a field in a custom database table
  59. Can’t use get_results() in ajax query
  60. Successful or Error Message after running mysql code in functions.php
  61. PHP/MySQL issues when running WP on EC2 cloud [closed]
  62. How to create another version of my site based on the same database
  63. Looking for most performant way to execute several similar WP queries within shortcodes
  64. Stumped on migration
  65. PHP code inside shortcodes
  66. Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
  67. WordPress Site Running Extremely Slow on Dedicated Server
  68. how to delete 30 day old data using PHP [closed]
  69. Echo a hierarchical list of post data from custom fields
  70. Get updated query results on page after insert in database
  71. WordPress not reflecting changed of the database
  72. How can I fix WordPress installation errors?
  73. Querying wpdb using PHP
  74. wpdb php get_var query to get ID for URL image doesn’t work for ID over 999
  75. How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
  76. Hacked WordPress website /Homepage redirect [closed]
  77. Refresh table data with Ajax
  78. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  79. Can’t Query Custom Table Using $wpdb Method
  80. Update postmeta after theme switch
  81. Creating Database Table vs. Adding MetaData to Post & User
  82. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  83. WordPress WP_Query without query GET parameters
  84. Fetching review value using wpdb class
  85. WordPress Custom Query: Combining Two Functions
  86. How to optimize and reduce excessive database queries
  87. Store GA Client ID in User DB
  88. PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  89. Need help with format of nested array in MySQL
  90. problem in using wpdb->prepare and a string placeholder
  91. Inserting other fields to existing registration form in a WordPress theme
  92. Splitting table data to pages with numbers
  93. Site doesnt work once PHP changed to 7.1
  94. How to detect if a revision was made by woocommerce or wordpress?
  95. WordPress WPDB::insert 13th param is always blank (only if format)
  96. Ajax not updating to database
  97. can’t delete a row from post_meta table
  98. retrieve wordpress post-meta using php not wordpress functions
  99. Splash pages on a high traffic site
  100. Submit cf7 form to cfdb as pdf/BLOB [closed]