Forums

Sorting posts alphabetically and ignoring articles (the, a, an) (1 post)

  1. blehn
    Member
    Posted 5 months ago #

    Hi,

    In troubleshooting this problem, I noticed the question has been asked many times but is never actually answered. If someone could provide a working example, I'm sure many people (including me) would be very grateful.

    I'm sorting my posts alphabetically by Title on a category page, like so:

    $posts = query_posts($query_string .
    '&orderby=title&order=asc&posts_per_page=-1');

    I'd like to exclude articles such as "the", "a", and "an" from the sorting criteria.

    e.g.

    Aardvard
    Antique
    The Apple
    Attic

    It seems the most straightforward solution would be a custom SQL query, perhaps in conjunction with an automatically generated database column that strips the articles, but I'm having trouble getting it working. Please help!

    Thanks!

Reply

You must log in to post.

About this Topic