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_id | emp_name | dept_name | emp_age |
|---|
| 60001 | WARNER | FRONT-END Developer | 26 |
| 60002 | CRISTIE | GAME deVeLoper | 30 |
| 60003 | RANGA | UX deVeLoper | 30 |
| 60004 | RANGA | UX deVeLoper | 30 |
| 60005 | PRAD | BACKEND 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.
