How to sort posts by last name (2nd word) on ONE category only?

You have 2 ways.

First is to write custom SQL query manualy for your request and loop that data.

Second is to loop your data on standard way, save in multidimensional array, filter, transform and reorder that array via PHP how you need and after that loop that data and print like content.

Booth ways are good but my recommendation is to write SQL query because is faster and cleaner.

Like I know WP don’t have a done solution. You need to build by own.

You need to build custom template for that special category and do that there.

Related Posts:

  1. Different post sort order within different categories
  2. How to choose a sort order (for posts) per category? (ideally when creating a new category)
  3. How to sort posts alphabetically based on a specific parent category
  4. How to Change Order of Posts in Admin?
  5. Setting Custom Sort Order of Posts within a Category
  6. Query posts from current year
  7. Display posts in alphabetical order for a particular category
  8. How to sort posts inside categories
  9. how to get post order by post id wp_query?
  10. Sort by last word in title
  11. How to list post as buch of category, and all of them
  12. Sort Posts Alphabetically Based on Specific Category (Divi)
  13. How to get the number of posts in a selected category?
  14. Sort posts by popularity/page views
  15. Show related posts by category but ignore one category
  16. Add custom field to all posts in specific category
  17. Single.php Active Category Class
  18. Most efficient way to list all categories and display a post for each of them?
  19. prevent showing posts of an specific category in admin posts section
  20. Auto set Post to Specific Categories
  21. New blog template to display only one category
  22. WordPress menu that shows all posts in a certain category like w3schools
  23. Filter Posts by Excluding Categories
  24. How can I list random authors from current post category?
  25. How do I render all posts of the same category in same layout?
  26. How to limit displayed posts on wordpress
  27. WordPress list posts from sub categories
  28. Select a random post from a specific category?
  29. How to filter posts that belong to a specific category only if that is the only category
  30. Category List (Archive) Page Template By Category
  31. List posts in a given category
  32. Why orderby=”date” does not support manually changed posts?
  33. Child_of not displaying all children posts.. via get_posts
  34. post categories
  35. How can i limit the number of posts created per category?
  36. Pulling in post category and children within category
  37. Get Posts Under Custom Taxonomy
  38. Prevent additional top level categories but allow more children
  39. How do I stop the loop from repeating in my category template?
  40. Excluding posts not working
  41. Limit the number of posts a category can have – newest post goes in, oldest one drops out, possible? plugin?
  42. Remove current category from post but display all others
  43. store posts_id of category into a varable?
  44. How do I show posts from another wordpress installation?
  45. How do I include the category next to the title of a post?
  46. How to show a custom taxonomy in the theme?
  47. How to import nested categories from XML file?
  48. Display a mixed list of posts and media
  49. Migrate posts from category and sub-category via SQL
  50. Posts Missing in Dashboard after update
  51. Display post number by category
  52. How to get post with slug and exclude categories
  53. Retrieving posts by their date and category
  54. Are post, page and category IDs unique to each other?
  55. Static pages not working
  56. Sort All Posts by Category Name in the Admin Panel?
  57. WordPress displays post on subcategory only
  58. Sidebar limiting to 10 posts?
  59. Natural sort / ordering wp_dropdown_categories
  60. How can I add a page that shows posts from a single category?
  61. Categories Listing and Highlighting current category item
  62. Display hierarchical categories/sub-categories for a single post only
  63. Can I show category name in url for only one of my categories?
  64. Author post count in category
  65. Current post categories and subcatecories outside of the loop
  66. Query prints posts without specific categories
  67. Why do I have categories with duplicate slugs?
  68. Automatic Table of contents with categories and posts
  69. Ajaxify Post Sort
  70. How to sort custom post’s category by id from the theme’s function.php?
  71. post categories – how to show only categories with a specific parent id
  72. Creating a “category” of featured posts
  73. Is it possible to remove actual post pages in wordpress but keep them in categories
  74. Need help with hiding an image within a post in a category
  75. WordPress not showing recent posts
  76. How to get post count including nested categories
  77. How to filter out post from a category not its subcategory in wordpress dashboard
  78. How can I display a specific number of post in a category via a url
  79. how to chang preview of list of articles of one category?
  80. Post of a specific category – not to be seen in paging previous/next post
  81. How to show main category related to that post
  82. Query category-specific, paginated posts and allow viewer to change sort order
  83. Display selected category on post page
  84. Sorting Posts by Date – get_blogs_of_user_id()
  85. Sort post by category using HTML Select tag
  86. Make assigning post to a specific category equivalent to assigning it to all categories
  87. How to use in_category?
  88. About number of posts in selected category
  89. How to get alphabetic listing x other posts, based on first letter post?
  90. Add default content to post (for specific category)
  91. Sort by category and then date?
  92. Category page shows “No Posts” but I do have two assigned
  93. Exclude a ‘portfolio’ custom category?
  94. ‘get_previous_post’ in same category returning (!empty) when no previous post in category exists
  95. excerpt in template for specific page
  96. Only show posts belonging to multiple cateogries at same time
  97. Wrap posts from a category in HTML
  98. Filter/Sort Post Form On Taxonomy page
  99. Error counting posts of category
  100. WordPress converting ‘ to ’ and – to –?

Leave a Comment