Order result using value with float type

• 

  • brunowego

  • February 17, 2020 at 6:15 am

  I have 10 guides registered on my WordPress. Each guide have a version (2.7, 2.8, 2.9, 2.10). The type of custom version field are text.

  I’m trying order this using version, but the output version is 2.9, not 2.10:

  
  $last_guide = new WP_Query( array(
  	'post_type'      => 'guide',
  	'posts_per_page' => 1,
  	'meta_key'       => 'version',
  	'orderby'        => 'meta_value_num',
  	'order'          => 'DESC'
  ) );
  

  
  SELECT
      SQL_CALC_FOUND_ROWS wp_posts.ID
  FROM
      wp_posts
      INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
  WHERE
      1 = 1
      AND (wp_postmeta.meta_key = 'version')
      AND wp_posts.post_type = 'guide'
      AND (
          wp_posts.post_status = 'publish'
          OR wp_posts.post_status = 'acf-disabled'
          OR wp_posts.post_status = 'private'
      )
  GROUP BY
      wp_posts.ID
  ORDER BY
      wp_postmeta.meta_value + 0 DESC
  LIMIT
      0, 1
  

  What can I do to fix it? Thanks.