CAST(expr AS type)

The type can be one of the following values(type可从下面类型中选):
BINARY
CHAR
DATE
DATETIME
SIGNED [INTEGER]
TIME
UNSIGNED [INTEGER]type

例：

select * from sunhaibing order by CAST(click as SIGNED) desc;

其中click是表sunhaibing中的一个字段