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. Sort posts by category name and title
  8. How to get order of posts?
  9. How to get Page/Post Gallery attachment images in order they are set in backend using WP_Query()?
  10. WP Query orderby meta key natural sort?
  11. Get posts by menu ID
  12. Slow SQL_CALC_FOUND_ROWS Query
  13. Loop through all tags & output posts in alphabetical list
  14. SQL query equivalent to WP User Query
  15. What’s wrong with this WP query?
  16. Stop all SQL_CALC_FOUND_ROWS wordpress queries
  17. How to count post meta key values for all posts in database
  18. Sorting Posts by custom field
  19. Group posts by meta_key
  20. How to search for posts IN OR title OR content OR author?
  21. Sorting meta_value as integer doesn’t work
  22. WP_Query hit max joins… How else can I build a search function that uses custom fields?
  23. Sort in WP_Query(), not filter? Is it possible?
  24. Would this post meta be better added to the post table rather than post_meta table
  25. Front End Sorting Questions
  26. Woocommerce custom loop to show all the products [closed]
  27. Sort by meta key on archive page
  28. Order By Multiple Meta Fields
  29. meta_query on a date range using an array of values
  30. How to speed up wp_query, took more 5s to run against 100k posts
  31. How to sort posts in admin by titles with dd.mm.yyyy format?
  32. Query Set Order By Author
  33. WordPress: Keep order of query_posts list of post ID’s using post__in
  34. SQL User Query by Multiple Roles using PHP
  35. WordPress Query is taking more then 20 second and stuck on creating index
  36. How to make orderby ‘meta_value_num’ OPTIONAL?
  37. Meta query with order by another custom field
  38. Get the Plugin Which Triggered a MySql Query in WordPress?
  39. Mysql query LIKE not working
  40. How to get posts on a specific date – WP Query
  41. Using WP_Query and WP_Meta_Query Outside of WordPress
  42. How to orderby meta_value_num with dollar ($) sign
  43. SQL query injection with fifu image
  44. Customize the Sorting Dropdown in WooCommerce use another list or more page
  45. Order (by ASC) posts with meta_key so posts without values are last
  46. How to sort store location by specific category order in WP store locations
  47. how to include orderby value that is empty?
  48. Why last row deleted when refresh page
  49. How to sort wordpress posts already selected by WP_QUERY
  50. WP Query – grouping posts by same meta key, adding together values from another key
  51. Woocommerce Get Orders By Meta Value
  52. Sort by price wpdb
  53. SQL to join u3g_users & u3g_meta_value with repeating data
  54. Custom Woocommerce Product Query
  55. How sort products by calculate value? ( custom post meta, price, option)
  56. Get authors list and sort them by recent posts
  57. Move some posts to end of sort order, even if there is a sort in the wp_Query already
  58. INNER JOIN custom tables – SQL Query
  59. use mysql variable in a $wpdb->query to reindex a column?
  60. One of two similar WP Query is very slow
  61. Order by value of Custom Field using url string
  62. Fix wp_term_relationships slow query in get_posts
  63. WP Query with meta queries
  64. WordPress Query optimaization for slow query
  65. Sorting query_posts() with a complex orderby filter
  66. Order 2 meta_queries differently in WP_Query?
  67. Sort posts on custom field AND after that sort on date?
  68. How to mix two orderby-parameters into one ordered result
  69. Query postmeta based on meta_value, return array of post_id
  70. Sorting Posts by Taxonomy thats not within the query’s $args
  71. Order Posts By Custom Field That is an array of objects
  72. Multiple wpostmeta.meta_key
  73. Ignoring ‘a’ when sorting posts
  74. Slow query when selecting with large meta query or post__in
  75. Display three sequential posts on each page load, without repeating previous
  76. Combine WP_Query with array of custom data to single loop without breaking the pagination
  77. Wrap group of wp query posts to parent div by date/year
  78. Sorting posts by meta values: 2 different orders
  79. WP_Query always returning the last custom post
  80. Sorting is not working in WordPress WP_Query
  81. How to sort a WP_Query array by post_name after an array_merge();
  82. Get a list of the last posts grouped by author and filtered by category
  83. Sorting: custom query with orderby meta_value_num THEN by title
  84. query_posts with sorting on a custom datestamp
  85. How to count post meta key values for all posts in database
  86. meta_query dates from an array
  87. Sort Posts with custom meta key by default which is currently set as optional
  88. Different sql queries count indicator on the main page [closed]
  89. Parsing External Table Arguments
  90. How to add a custom field and incrementing value for all the published posts
  91. wordpress sorting using array merge by price in ascending order but price with 0 must be show last
  92. WordPress query very slow on +/- 300k DB entries and 7 INNER JOIN
  93. have_posts order by title descending
  94. WP_Query – order with usort by custom meta
  95. SQL query into to WP query
  96. Bulk delete comments, foreach loop
  97. Sort by multiple columns using get_posts
  98. WP Query order posts not working
  99. How to `’orderby’ => ‘meta_value_num’` in a series of orderby parameters
  100. query loop “inherit query from template” prevents setting sort order
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)