Structured Query Language: Part 2

Introduction

You saw some Structured Query Language (SQL) commands in my previous article. And now, I share some more commands of SQL. If you haven't read my previous article on SQL, please then read that article first because, in that article, I explained how to create databases and tables. Also, how to insert values into the tables and more. So please read the first article from here.

Before reading this article, I will suggest you all go through my previous article-

• Structured Query Language: Part 1

Ok, let's start.

First, we show how many values we have in the database as in the following:

Output

"LIKE "

Like is used when searching for a specific pattern; for example, we only need the person whose name starts with the letter "s" or ends with "z." So let's see this practice.

Start with a specific character.

Output

It ends with a specific character

Output

Matched any specific pattern

Output

"IN" Operator

The In operator is used to select multiple values.