Shulou(Shulou.com)06/01 Report--

This article will explain in detail the method of converting varchar to int in mysql. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

The method of mysql to int: 1, through manual conversion type; 2, using MySQL function CAST to achieve conversion; 3, using MySQL function CONVERT to achieve conversion.

Convert MySQL varchar to int

1. Manual conversion type (direct + 0)

Example:

Select server_id from cardserver where game_id = 1 order by server_id+0 desclimit 10

two。 Use the MySQL function CAST:

Example:

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

3. Use the MySQL function CONVERT:

Example:

Select server_id from cardserver where game_id = 1 order by CONVERT (server_id,SIGNED) desc limit 10

Note:

CAST function, CONVERT usage

CAST (expr AS type), CONVERT (expr,type), CONVERT (expr USING transcoding_name)

The CAST () and CONVERT () functions can be used to get a value of one type and 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] the method of converting varchar to int in mysql is shared here. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.