MID

The MID() Function used to extract the character from the text field.

The basic syntax is as follows:

SELECT MID(Column_Name,Start[,Length]) FROM Table_Name

Employee
Emp_id	Name	Surname	Salary	Dept_id
1	Rajesh	Khanna	45000	2
2	Sneha	Gupta	55000	4
3	Sandeep	Nehte	95000	1
4	Kirti	Patil	25000	3
5	Nilesh	Jadhav	45000	3
6	Dipesh	Das	35000	5
7	Kailash	Rane	62000	1
8	Kavita	Deshpande	48000	3
9	Sanjay	Datt	50000	3
10	Shruti	Hasan	78000	1

Syntax For SQL:

SELECT Emp_id,MID(Name,1,4),Surname, salary,Dept_id FROM Employee ORDER BY Emp_id;

After Execute: 

Emp_id	Name	Surname	Salary	Dept_id
1	Raje	Khanna	45000	2
2	Sneh	Gupta	55000	4
3	Sand	Nehte	95000	1
4	Kirt	Patil	25000	3
5	Nile	Jadhav	45000	3
6	Dipe	Das	35000	5
7	Kail	Rane	62000	1
8	Kavi	Deshpande	48000	3
9	Sanj	Datt	50000	3
10	Shru	Hasan	78000	1