SQL MID () Example tutorial

SQL MID () Example tutorial

Mid () function
The mid () function is used to extract text fields of characters.

Database mid () syntax

SELECT MID(column_name,start[,length]) FROM table_name

 
 

  
  
 
   
 
    
Parameter
 
    
Description
 
   
 
   
 
    
column_name
 
    
Required. The field to extract characters from.
 
   
 
   
 
    
start
 
    
Required. Specifies the starting position (starts at 1).
 
   
 
   
 
    
length
 
    
Optional. The number of characters to return. If omitted, the MID() function returns the rest of the text.
 
   
 
  
 
 

Let's see an instance.

 
 

  
  
 
   
 
    
 
 
    
LastName
 
    
FirstName
 
    
Address
 
    
City
 
   
 
   
 
    
1
 
    
Hansen
 
    
Ola
 
    
Timoteivn 10
 
    
Sandnes
 
   
 
   
 
    
2
 
    
Svendson
 
    
Tove
 
    
Borgvn 23
 
    
Sandnes
 
   
 
   
 
    
3
 
    
Pettersen
 
    
Kari
 
    
Storgt 20
 
    
Stavanger
 
   
 
  
 
 

Now, we want to extract the first four characters from the "city" column.

We use the following SELECT statement:
SELECT MID(City,1,4) as SmallCity FROM Persons
Result.
  
  

   
   
 
    
 
     
SmallCity
 
    
 
    
 
     
Sand
 
    
 
    
 
     
Sand
 
    
 
    
 
     
Stav