order by numbers where can be hyphens - mysql -


i have query

select * table order numbers asc 

numbers are: 32,-,11,76,-

what -,-,11,32,76 (hyphens @ start)

what change in query hyphens @ end ?

here first tried sort using conditional flow type casting

select * `table` order numbers = '-', numbers+0 asc 

if want reverse negate conditional flow

select * `table` order numbers != '-', numbers+0 asc 

Comments

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

php - .htaccess mod_rewrite for dynamic url which has domain names -

Website Login Issue developed in magento -