Title: Sorting Numeric Columns query
Last modified: August 30, 2016

---

# Sorting Numeric Columns query

 *  Resolved [ibisman001](https://wordpress.org/support/users/ibisman001/)
 * (@ibisman001)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/sorting-numeric-columns-query/)
 * I have installed your WP-DB-Table-Editor plugin and I am trying it out.
    I have
   a table that I can browse via phpMyAdmin. Lots of INT columns. I click on a INT
   column in the browser and sorting is fine.
 * When I browse the table table via WP-DB-Table-Editor and try to sort a numeric
   column, the values are sorted alphabetically. e.g. 1, 10, 120, 2, 250, 3,40,5…
 * Any ideas how to make the sort in numerical sequence?
 * Cheers,
    Peter
 * [https://wordpress.org/plugins/wp-db-table-editor/](https://wordpress.org/plugins/wp-db-table-editor/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [bobbysmith007](https://wordpress.org/support/users/bobbysmith007/)
 * (@bobbysmith007)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/sorting-numeric-columns-query/#post-6733320)
 * Alright, there was some problem with the type detection, so I just replaced it
   with a system of trying to cast to number and if it works great. This seemed 
   to resolve the bug. Thanks for your assistance in tracking down this matter.
 * Please try out 1.5.3 to get this fixed on your end 🙂
 * Cheers,
    Russ

Viewing 1 replies (of 1 total)

The topic ‘Sorting Numeric Columns query’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-db-table-editor.svg)
 * [WP-DB-Table-Editor](https://wordpress.org/plugins/wp-db-table-editor/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-db-table-editor/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-db-table-editor/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-db-table-editor/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-db-table-editor/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-db-table-editor/reviews/)

## Tags

 * [sorting](https://wordpress.org/support/topic-tag/sorting/)

 * 1 reply
 * 2 participants
 * Last reply from: [bobbysmith007](https://wordpress.org/support/users/bobbysmith007/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/sorting-numeric-columns-query/#post-6733320)
 * Status: resolved