Menu
Community /Pin to ProfileBookmark
@NogDogJan 31.2005 — #In MySQL:
So, to check if a boolean field is set to true, any of the following would work:
If the purpose of a column is to record a boolean value/condition, then I am an advocate of using a boolean type: it makes your data design more self-documenting.@NogDogJan 31.2005 — #
Well, it sort of has a boolean type. Fromhttp://dev.mysql.com/doc/mysql/en/numeric-type-overview.html .
Use of Boolean – more efficient ?
In a db is using a boolean field more efficient that using a char field with one chracter as an
indicator flag ?
This is especially relevent when I only have two options “yes or no”.
eg. if I use a single char field callad flag1, I can put a “y” in it and test it
with a WHERE eg
$sql = “SELECT * FROM stuff WHERE flag1 =”y”
IF I used a boolean field – lets say flag2, and set it to true ( how do I do that ?)
How do I test it in the WHERE statement ?
$sql = “SELECT * FROM stuff WHERE flag2 ???
Anyway – if I do this is it somehow better or more efficient ?
Thanks – you can guess that I haven’t used bool. values much !
Sign in
to post a comment6 Comments(s) ↴
0
@NogDogJan 31.2005 — #In MySQL:<i>
</i>mysql> SELECT TRUE, True, true, FALSE, False, false;
--> 1, 1, 1, 0, 0, 0
So, to check if a boolean field is set to true, any of the following would work:
<i>
</i>SELECT * FROM my_table WHERE boolean_column = TRUE;
SELECT * FROM my_table WHERE boolean_column = true;
SELECT * FROM my_table WHERE boolean_column = 1;
If the purpose of a column is to record a boolean value/condition, then I am an advocate of using a boolean type: it makes your data design more self-documenting.
0
@NogDogJan 31.2005 — #[i]Originally posted by ShrineDesigns [/i]
[B]i set the field type to INT(1) DEFAULT '0' it makes test true or false a little easier becase true == 1 and false == 0
to my knowledge MySQL does not have a field type of BOOLEAN [/B][/QUOTE]
Well, it sort of has a boolean type. From
BIT , BOOL , BOOLEAN
These are synonyms for TINYINT(1). The BOOLEAN synonym was added in MySQL 4.1.0. A value of zero is considered false. Non-zero values are considered true.
In the future, full boolean type handling will be introduced in accordance with standard SQL.[/quote]