Skip to content
Related Articles

Related Articles

Improve Article

How to find all Employee records containing a Specific Word regardless case-sensitive in SQL

  • Difficulty Level : Medium
  • Last Updated : 07 Apr, 2021

In this article, we will cover how to find all Employee records containing a Specific Word regardless of case-sensitive in SQL and will discuss steps by steps.  

Introduction :
We will discuss, how to find all employee records containing a specific word regardless of the case-sensitive. We create the database employee and check for the following query step by step. Considering this table we find all employee records with the developer as the case-insensitive word as follows.

 dept_idemp_namedept_nameemp_age
 60001WARNERFRONT-END Developer

26

 60002CRISTIEGAME deVeLoper

30

 60003RANGAUX deVeLoper

 30 



 60004RANGAUX deVeLoper

 30 

 60005PRADBACKEND DEVeLoper

40

Step-1: Creating a database –
Creating a database using the following SQL query as follows.

syntax:
CREATE DATABASE database_name;

Output :

Step-2: Using the database –
Using the database company as follows.

syntax:
USE database_name;

Output :



Step-3: Adding a table –
Adding a table employee into a database company as follows.

syntax:
CREATE TABLE table_name
( column_name1 data_type1 ,
column_name2 data_type2 ,
column_name3 data_type3 ,
.
.
column_nameN data_typeN , );     

Step-4: Creating a table –
Creating a table employee with columns (dept_id,emp_name,dept_name,emp_age) into a database company as follows.

Output :

Step-5: Verifying columns and data types –
Columns and their data types by DESCRIBE query as follows.

syntax:
DESCRIBE table_name;

Output :

Step-6: Inserting rows into a table –
Inserting rows into a table employee by using the following SQL query as follows.

syntax:
INSERT INTO table_name  VALUES(column1_data,column2_data,......columnN_data);

Output :



Step-7: Verifying inserted data –
Check the inserted data in the database using the select query as follows.

syntax:
SELECT * FROM table_name;

Output :

Examples :
Let’s understand the concept with the help of examples as well for better understanding.

Example-1 :
As observed in the table the developer word is case-insensitive but all the employee records with the developer should be retrieved so the query to that is as follows.

Syntax :

SELECT*
FROM table_name
WHERE column_name LIKE 'PATTERN';

Selecting data Querying –

SELECT* 
FROM employee
WHERE dept_name LIKE '%DEVELOPER';

Output :
Here in this table, all the records of an employee with the developer as dept name are obtained without considering the case.

Example-2 :
Query to obtain all employee names with the developer as dept_name with case insensitive as follows.

Output :
Here in this example, all the names of an employee with a developer are obtained without considering the case.

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

My Personal Notes arrow_drop_up
Recommended Articles
Page :