CODEWITHSUNDEEP
phpwordpress
Gago Design
Gago Design

Reputation: 992

Wordpress - sort posts containing numbers and letters alphabetically

I'm trying to sort the posts in WP alphabetically but I'm not getting the result I was expecting. This is what I get:

  NOZ - 1 apple 
  NOZ - 10 orange 
  NOZ - 11 banana
  NOZ - 2 tree 
  NOZ - 3 grass

This is what I'd like to get:

  NOZ - 1 apple 
  NOZ - 2 tree 
  NOZ - 3 grass 
  NOZ - 10 orange 
  NOZ - 11 banana

This is my PHP code:

<?php $loop = new WP_Query( array('post_type' => 'myPosts', 'orderby' => 'title', 'order' => 'ASC', 'posts_per_page' => -1 )    ); ?>

Thanks a lot for your help.

Upvotes: 2

Views: 2295

Answers (1)

Nadir Latif
Nadir Latif

Reputation: 3773

You can add a MySQL function to the orderby field. For example:

'orderby' => 'CAST(SUBSTRING(title, 7) as unsigned)'

The substring function extracts all characters after and including the character at the 7th position.

The cast function converts the extracted characters to an unsigned integer. The cast function works from left to right. It discards all characters that are not numeric. A similar question was answered here: SQL order string as number

Upvotes: 8

Related Questions