Click here

Boolean operator

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."



Top Terms

Connect with Webopedia

  • The Difference Between Adware & Spyware

    Not technically fitting into either the virus or spam category we have spyware and adware, which are growing concerns for Internet users.

    Read More »

Did You Know? Archive »

  • Quick Reference Archive »