How to convert bool to int in MySql

Question

I'm new to MySql. So I don't know many things like Casting of data types. How can I convert bool to int in MySql. And also how can I convert decimal to Int in MySql.

@NAVEED : I want to cast the Bool type to Int for ex: DECLARE bo BOOL; SET bo = TRUE; SELECT CAST(bo AS INT); — Fasal, Jun 07 '11 at 05:05

score 14 · Accepted Answer · answered Jun 07 '11 at 05:01

14

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 */

answered Jun 07 '11 at 05:01

BenMorel

31,815
47
169
296

How to convert bool to int in MySql

1 Answers1

Linked