How to convert bool to int in MySql

Question

I am new to MySql. Therefore, I do not know many things, such as Data Casting. How to convert bool to int in MySql. And also, how can I convert the decimal value to Int in MySql.

Answer 1

Pointing the boolean type to integer:

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

The same goes for decimal numbers and strings:

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

Answer 2

Let me do this for you.