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

Vangie Beal
Vangie Beal
Vangie Beal is a freelance business and technology writer covering Internet technologies and online business since the late '90s.

Top Articles

The Complete List of 1500+ Common Text Abbreviations & Acronyms

Text Abbreviations reviewed by Web Webster   From A3 to ZZZ we list 1,559 SMS, online chat, and text abbreviations to help you translate and understand...

How to Create a Website Shortcut on Your Desktop

Website Shortcut on Your Desktop reviewed by Web Webster   This Webopedia guide will show you how to create a website shortcut on your desktop using...

Windows Operating System History & Versions

The Windows operating system (Windows OS) refers to a family of operating systems developed by Microsoft Corporation. We look at the history of Windows...

First to Fifth Generations of Computers

Reviewed by Web Webster   Learn about each of the 5 generations of computers and major technology developments that have led to the computing devices that...

What is a Passphrase?

What is a passphrase? A passphrase is a string of words used to help...

What is UID?

A unique identifier (UID) is a character string, either numeric or alphanumeric, that...

How to Use Google...

Updated by Jenna Phipps   Google Hangouts is a cloud-based messaging and video chat application...