Case insensitive ORDERBY in wpquery

  1. As stated above, your orderby parameter should be set to meta_value, not restaurant.

  2. Using phpMyAdmin or some other tool, look at your database. With any newer installation of WordPress, your tables should have a collation of utf8mb4_unicode_ci. That means that the table is storing its data in UTF-8 4-byte unicode character set. That “ci” at the end means “case insensitive”.

If your collation is not correct, then you may need to convert your data. This is not as easy as it sounds all the time, so make sure you get a quality backup of your database first.

Related Posts:

  1. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  2. Return only Count from a wp_query request?
  3. Use REGEXP in WP_Query meta_query key
  4. Sorting: custom query with orderby meta_value_num THEN by title
  5. Order by DESC, ASC in custom WP_Query
  6. How to prevent execution of default query, while preserving ability to use WP_Query in template?
  7. How to get order of posts?
  8. How to get Page/Post Gallery attachment images in order they are set in backend using WP_Query()?
  9. WP Query orderby meta key natural sort?
  10. Get posts by menu ID
  11. SQL query equivalent to WP User Query
  12. What’s wrong with this WP query?
  13. Stop all SQL_CALC_FOUND_ROWS wordpress queries
  14. How to count post meta key values for all posts in database
  15. Group posts by meta_key
  16. Sorting meta_value as integer doesn’t work
  17. WP_Query hit max joins… How else can I build a search function that uses custom fields?
  18. Sort in WP_Query(), not filter? Is it possible?
  19. Would this post meta be better added to the post table rather than post_meta table
  20. Front End Sorting Questions
  21. Woocommerce custom loop to show all the products [closed]
  22. Order By Multiple Meta Fields
  23. meta_query on a date range using an array of values
  24. How to speed up wp_query, took more 5s to run against 100k posts
  25. How to sort posts in admin by titles with dd.mm.yyyy format?
  26. Query Set Order By Author
  27. WordPress: Keep order of query_posts list of post ID’s using post__in
  28. Mysql query LIKE not working
  29. How to get posts on a specific date – WP Query
  30. Using WP_Query and WP_Meta_Query Outside of WordPress
  31. How to orderby meta_value_num with dollar ($) sign
  32. How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
  33. Improve wp query perfomance on large db
  34. why update and delete query not worked in custom table?
  35. Performance when getting post meta for post retrieved by meta value
  36. Hide Administrators From User List except current user (administrator)
  37. Using hook to use DISTINCT in a wp_query
  38. pagination with ‘no_found_rows’ => true,
  39. WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
  40. WordPress Comments sort by custom meta key
  41. Order by summing multiple values
  42. Understanding the orderby in WP_Query?
  43. How to implement a new row_count method in WordPress?
  44. Help ordering Post loop by two meta values
  45. How to sort a custom wordpress query by combination of meta values?
  46. Query most popular terms by taxonomy over 2 week period
  47. WP Group posts by year(desc) > month(desc) > date(asc)
  48. Which is faster wpdb & get_row or wp_query & ge_post_meta?
  49. Does wp track views for posts?
  50. Sort WordPress Posts Meta value by Week not Day
  51. how update data through ajax and jquery
  52. How to order WP_Query to group results?
  53. I am having problem sorting custom post type using WP_Query
  54. how to get Nearby zipcode
  55. How I can change the condition or compare operator for WP_Query in pre_get_posts
  56. Update query for wp_posts and wp_postmeta
  57. How to use a dropdown to filter posts by custom field
  58. mysql query order by
  59. Display all posts in a custom post type, grouped by a custom taxonomy. How to sort the posts alphabetically and the terms by ID?
  60. WP Query and date format
  61. WP_Query with page_ids in arguments without a result
  62. How to sort queried pages by an array of page ids?
  63. get_var is neither a string, integer, or array …?
  64. SQL query injection with fifu image
  65. Customize the Sorting Dropdown in WooCommerce use another list or more page
  66. Order (by ASC) posts with meta_key so posts without values are last
  67. how to include orderby value that is empty?
  68. Why last row deleted when refresh page
  69. How to sort wordpress posts already selected by WP_QUERY
  70. WP Query – grouping posts by same meta key, adding together values from another key
  71. Woocommerce Get Orders By Meta Value
  72. SQL to join u3g_users & u3g_meta_value with repeating data
  73. Custom Woocommerce Product Query
  74. How sort products by calculate value? ( custom post meta, price, option)
  75. Move some posts to end of sort order, even if there is a sort in the wp_Query already
  76. INNER JOIN custom tables – SQL Query
  77. use mysql variable in a $wpdb->query to reindex a column?
  78. Order by value of Custom Field using url string
  79. Fix wp_term_relationships slow query in get_posts
  80. WP Query with meta queries
  81. WordPress Query optimaization for slow query
  82. Sorting query_posts() with a complex orderby filter
  83. Order 2 meta_queries differently in WP_Query?
  84. How to mix two orderby-parameters into one ordered result
  85. Query postmeta based on meta_value, return array of post_id
  86. Sorting Posts by Taxonomy thats not within the query’s $args
  87. Order Posts By Custom Field That is an array of objects
  88. Slow query when selecting with large meta query or post__in
  89. Combine WP_Query with array of custom data to single loop without breaking the pagination
  90. Wrap group of wp query posts to parent div by date/year
  91. Sorting posts by meta values: 2 different orders
  92. WP_Query always returning the last custom post
  93. Get a list of the last posts grouped by author and filtered by category
  94. Sorting: custom query with orderby meta_value_num THEN by title
  95. query_posts with sorting on a custom datestamp
  96. meta_query dates from an array
  97. Different sql queries count indicator on the main page [closed]
  98. wordpress sorting using array merge by price in ascending order but price with 0 must be show last
  99. WordPress query very slow on +/- 300k DB entries and 7 INNER JOIN
  100. Bulk delete comments, foreach loop