I current make use of the following line to list out my wordpress posts from the-Z, however the problem I've with this particular is the fact that all posts beginning with 'the' (which are much!) are listed underneath the T (as always).

query_posts('orderby=title&order=asc&posts_per_page=999&cat=3');

I wish to prevent this and show posts starting with 'the postname' as 'postname, the' to create the A-Z sorting better.

Wouldso would I accomplish this?

I believe you will find two methods for getting this data out:

  • make use of the query_posts() function, take away the "the" after which resort in PHP
  • Write a custom MySQL query to fetch the information and carry out the string alternative

I believe the very first option would be best but I'm not sure enough about Wordpress to be aware what query_posts() returns so can't go further having a solution.