Filtering: LIKE, IN, BETWEEN, AND, OR, NOT

Introduction

When writing SQL queries, having an understanding of the concept of filtering is very important because oftentimes, we want to get only specific rows or columns from a table rather than the whole table itself. Most of the time, the filtering is done with the WHERE keyword. In order to get a basic understanding of what this keyword does, please check out this AlgoDaily tutorial.

Back to our tutorial; we will use the WHERE statement in all examples, together with some other very important keywords: LIKE, IN, BETWEEN, AND, OR, and NOT. All the examples we will go through in this lesson will be based on the table shown below. The name of the table is Person.