We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

which are the boolean symbols [closed]

asked 2018-02-18 18:32:17 +0200

robert leleu gravatar image

updated 2020-07-27 00:06:43 +0200

Alex Kemp gravatar image

I want to select TRUE from a table which include a boolean field. When displayed the field show 3 icons

  1. an empty square
  2. a checked square
  3. a dash in the square

how to select any of these "values" by a SQL "WHERE" condition ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-27 00:06:51.221691

2 Answers

Sort by » oldest newest most voted

answered 2018-02-18 19:14:26 +0200

peterwt gravatar image

Empty square indicates FALSE
Tick in square indicates TRUE
Black square inside square indicates NULL

For the WHERE clause use =FALSE, =TRUE, IS NULL

edit flag offensive delete link more

answered 2018-02-18 19:12:24 +0200

Ratslinger gravatar image


The three icons are a tristate setting - TRUE, FALSE or undefined. The WHERE conditions:

    this is checked square

    this is empty square

    this is dash in square

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-02-18 18:32:17 +0200

Seen: 336 times

Last updated: Feb 18 '18