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
– Fasal, Commented Jun 7, 2011 at 5:05

BenMorel · Accepted Answer · 2011-06-07 05:01:10Z

15

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 7, 2011 at 5:01

BenMorel

37k52 gold badges208 silver badges339 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert bool to int in MySql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related