SQL MID () Use instance tutorial

SQL MID () Use instance tutorial

Mid () function
The mid () function is a text field used to extract 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 look at an example.

 
   
   
 
    
    
 
     
 
      
&nbs P; 
 
      
lastname 
 
      
firstname 
 
      
address 
 
      
city 
 
     
 
     
 
      
 1 
 
      
 Hansen 
 
      
 ola 
 
      
 timoteivn ten 
 
      
 sandnes 
 
     
 
     
 
      
 2 
 
      
 svendson 
 
      
 Tove 
 
      
 borgvn 
 
      
 sandnes 
 
     
 
     
 
      
3 
 
      
 Pettersen 
 
      
 Kari 
 
      
 storgt 
 
      
 Stavanger 
 
     
 
    
  
   
   

 
   
   

    
     Now we're going to extract the top four characters from the "City" column above.

  
    
    
 
    
    
 We use the following SELECT statement: 
    
    
 
    
    
 Select MID (city,1,4) as smallcity from Persons 
 
    
    
 results. 
 
    
    
 
     
     
 
      
      
 
       
 
        
smallcity 
 
       
 
       
 
        
 Sand 
 
       
 
       
 
        
 Sand 
 
       
 
       
 
        
 Stav