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
Post a Comment