How to convert bool to int in MySql

I'm new to MySql. So I don't know many things like Casting of data types. 开发者_如何学JAVAHow can I convert bool to int in MySql. And also how can I convert decimal to Int in MySql.

Typecasting boolean to integer:

SELECT CAST(1=1 AS SIGNED INTEGER); /* 1 */

Same for decimal and strings:

SELECT CAST("1.23" AS SIGNED INTEGER); /* 1 */