Table of Contents
    Home / Definitions / Boolean Operator
    Development 1 min read

    There are five Boolean operators that can be used to manipulate TRUE/FALSE values. These operators have the following meanings, where x and y represent values of TRUE or FALSE.

    The OR operator is often called an inclusive OR, whereas XOR is an exclusive OR.

    Boolean operators are used widely in programming and also in forming database queries. For example, the query

    SELECT ALL WHERE LAST_NAME = “Smith” AND FIRST_NAME = “John”

    finds all records with the name John Smith. But the query

    SELECT ALL WHERE LAST_NAME = “Smith” OR FIRST_NAME = “John”

    finds all records with the last name “Smith” or the first name “John.”