LIKE operator returns a query that is similar to a set description.
Syntax:
--LIKE
SELECT column_1, column_2
FROM table_name
WHERE column_1 LIKE 'statement%';Example: How do you find the exact customer that the store manager is asking for?
--Return the first name and last name using the LIKE operator of a person known as "JEN"
SELECT first_name, last_name
FROM customer
WHERE first_name LIKE 'Jen%';## first_name last_name
## 1 Jennifer Davis
## 2 Jennie Terry
## 3 Jenny CastroExample: How do you find the exact customer that the store manager is asking for?
--Return the first name and last name using the LIKE operator of a person known as "JEN"
SELECT first_name, last_name
FROM customer
WHERE first_name LIKE 'Jen%';## first_name last_name
## 1 Jennifer Davis
## 2 Jennie Terry
## 3 Jenny Castro--Return the first name and last name using the LIKE operator of a person known as "JEN"
SELECT first_name, last_name
FROM customer
WHERE first_name LIKE '%er%';## first_name last_name
## 1 Jennifer Davis
## 2 Kimberly Lee
## 3 Catherine Campbell
## 4 Heather Morris
## 5 Teresa Rogers
## 6 Cheryl Murphy
## 7 Katherine Rivera
## 8 Theresa Watson
## 9 Beverly Brooks
## 10 Sherry Marshall
## 11 Esther Crawford
## 12 Amber Dixon
## 13 Valerie Black
## 14 Bertha Ferguson
## 15 Veronica Stone
## 16 Geraldine Perkins
## 17 Bernice Willis
## 18 Roberta Harper
## 19 Terri Vasquez
## 20 Gertrude Castillo
## 21 Vera Mccoy
## 22 Terry Carlson
## 23 Sherri Rhodes
## 24 Robert Baughman
## 25 Christopher Greco
## 26 Jerry Jordon
## 27 Walter Perryman
## 28 Peter Menard
## 29 Roger Quintanilla
## 30 Albert Crouse
## 31 Terry Grissom
## 32 Gerald Fultz
## 33 Jeremy Hurtado
## 34 Jeffery Pinson
## 35 Herbert Kruger
## 36 Frederick Isbell
## 37 Alexander Fennell
## 38 Bernard Colby
## 39 Leroy Bustamante
## 40 Derek Blakely
## 41 Jerome Kenyon
## 42 Derrick Bourque
## 43 Herman Devore
## 44 Vernon Chapa
## 45 Roberto Vu
## 46 Lester Kraus
## 47 Tyler Wren
## 48 Gilbert Sledge
## 49 Chester Benner
## 50 Elmer Noe
## 51 Javier Elrod
## 52 Fernando Churchill
## 53 Everett Banda
## 54 Alberto Henning
## 55 Perry Swafford
## 56 Sergio Stanfield
## 57 Terrance Roush
## 58 Terrence Gunderson