MySQL type conversion uses cast to convert varchar to int type sort

MySQL provides us with two types of conversion functions: cast and convert, how can we let go of the ready-made stuff?

1 BINARY[(N)]2 CHAR[(N)]3 DATE4 DATETIME5 DECIMAL6Signed[INTEGER]7  Time8UNSIGNED[INTEGER]

Example:

--use cast to convert varchar to int type sort select server_id from cardserver where game_id = 1 order by CAST (server_id as signed) DESC limit 10;--using convert to convert varchar to int type sort select server_id from cardserver where game_id = 1 order by CONVERT (server_id,signed) des C Limit 10

MySQL type conversion uses cast to convert varchar to int type sort