Sql Query To Use a ' SELECT ' statement with LIKE Clause

To retrieve a record having a specific pattern in a record from the existing created table. Then we can use a ' WHERE ' Clause with LIKE Operator.

% - In 1st statement, it will retrieve the first_name having specific syntax “ra” in it from the table employees.
_ - In 2nd statement,it will retrieve the first_name having specific syntax “ar” in it with one character below it and as many as character above it, from the table employees.
_ and __ - In 3rd statement,it will retrieve the first_name having specific syntax “ar” in it with one character below it and two character above it, from the table employees.
%a _r% - In 4th statement,it will retrieve the value that having one character between a and r, start and end with any number of characters below and above a_r, from the table employees.

Database

Theme

Enter - Select * from table_name;

SQL Query

SELECT 'Like Clause with % is used above and below ar'; SELECT * FROM employees WHERE first_name LIKE '%ra%'; SELECT 'Like Clause with _ and % is used below and above ar respectively'; SELECT * FROM employees WHERE first_name LIKE '_ar%'; SELECT 'Like Clause with _ is used below and __ is used above ar'; SELECT * FROM employees WHERE first_name LIKE '_ar__'; SELECT 'Like Clause will retrieve the value that having one character between a and r, start and end with any number of characters below and above a_r'; SELECT * FROM employees WHERE first_name LIKE '%a_r%';

Output

Similar Program

#	Program	Language
1	Sql Query to Delete Records	SQL
2	Sql Case Sensitive Example 2	SQL
3	Sql Query To Retrieve Record Using Where Condition	SQL
4	Sql Case Sensitive Example 3	SQL
5	Sql Example To Rename Table Name Using Alter Command	SQL
6	Sql Case Sensitive Query Without Semicolon	SQL
7	Sql Query To Use DEFAULT Constraint	SQL
8	Sql Query To Drop Table	SQL
9	Sql Query To Insert The Record In The Table Without Defining The Column Name.	SQL
10	Sql Query To Use a ' SELECT ' statement with OR Operator	SQL
11	Sql Case Sensitive Example 4	SQL
12	Sql Query To Use a Inner Joins	SQL
13	Sql Query To Update Multiple Column	SQL
14	Sql Query to use a Not Null Constraint	SQL
15	Sql Query to retrieve data using Order By in Random Order	SQL
16	Sql Query To Use a ' SELECT ' statement with HAVING Clause	SQL
17	Sql Query to retrieve data using Order By in Descending Order	SQL
18	Sql Query To Insert The Record In The Table By Defining The Column Name	SQL
19	Sql Query to Truncate Table	SQL
20	Sql Query To Insert Multiple Records At A Time In The Table	SQL
#	Program	Language

Sql Query To Use a ' SELECT ' statement with LIKE Clause

Similar Program

About Fresherbell

Important Links

Social Media