# Create boolean field in mysql

**URL:** <https://forum.kirupa.com/t/create-boolean-field-in-mysql/185378>\
**Category:** Uncategorized\
**Created:** [April 12, 2006, 9:53pm UTC](https://forum.kirupa.com/t/create-boolean-field-in-mysql/185378 "2006-04-12T21:53:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![devinstar](https://avatars.discourse-cdn.com/v4/letter/d/e495f1/32.png) [@devinstar](https://forum.kirupa.com/u/devinstar)\
**Post date:** [April 12, 2006, 9:53pm UTC](https://forum.kirupa.com/t/create-boolean-field-in-mysql/185378/1 "2006-04-12T21:53:38Z")

</div>

Hi,

Want to create a boolean field in mysql for a table detailing what users are online and who are not.

What type should I set the field to as I can’t seem to see boolean.

---

<div class="post-metadata">

**Author:** ![JoshuaJonah](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/joshuajonah/32/1775_2.png) [@JoshuaJonah](https://forum.kirupa.com/u/JoshuaJonah)\
**Post date:** [April 12, 2006, 9:59pm UTC](https://forum.kirupa.com/t/create-boolean-field-in-mysql/185378/2 "2006-04-12T21:59:32Z")

</div>

it’s usuallu just “boolean” but you could just use an “INT” field with a vlue of 1 or 0 instead, yes?

---

<div class="post-metadata">

**Author:** ![bwh2](https://avatars.discourse-cdn.com/v4/letter/b/8c91f0/32.png) [@bwh2](https://forum.kirupa.com/u/bwh2)\
**Post date:** [April 12, 2006, 10:33pm UTC](https://forum.kirupa.com/t/create-boolean-field-in-mysql/185378/3 "2006-04-12T22:33:05Z")

</div>

i would use BIT. 1 for true. 0 for falsel