The method of converting varchar type to int type in MYSQL database _mysql

In the article to tell you the MySQL database in the transformation of int varchar caused by the slow query, this article to introduce the MySQL database in the varchar type into the type of int, look at it!

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

The CAST () and CONVERT () functions can be used to get a value of one type and to produce a value of another type.

This type can be one of the following values:

binary[(n)]
char[(n)]
DATE
DATETIME
DECIMAL
signed [integer]
time
UNSIGNED [integer ]

So we can also use cast to solve the problem:

Select server_id from cardserver where game_id = 1 order by CAST (server_id as signed) DESC limit 10

You can also use convert to fix this problem:

Select server_id from cardserver where game_id = 1 order by CONVERT (server_id,signed) DESC LIMIT 10

Ps:

MySQL varchar type conversion int type

 SELECT * from Gyzd_yysinfo order by cast (Yysid as signed INTEGER)

Or

SELECT * from Gyzd_yysinfo order by cast (Yysid as UNSIGNED INTEGER)

The above is a small set to introduce the MySQL database of the varchar type into the type of int, hope to help everyone, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!