ansaurus

Question

Answer 1

+1 A:

SELECT  *
FROM    mytable
ORDER BY
        CAST (mycol AS DECIMAL)

Quassnoi 2009-10-26 14:34:20

thanks Quassnoi

ntan 2009-10-26 14:35:34

@Quassnoi: Just wondering, but is CASTing more efficient than ORDER BY mycol+0

dnagirl 2009-10-26 14:40:09

nice idea i test drive it

ntan 2009-10-26 14:42:26

`@dnagirl`: `DECIMAL` will silently truncate everything beyond the `[0-9]` range, `mycol + 0` (which implies `CAST AS DOUBLE`) will issue a warning. As for performance, I think they're identical.

Quassnoi 2009-10-26 14:47:05

ansaurus

tags:

views:

answers:

mysql order varchar field as integer

related questions