How to Use the SQL select LIKE Parameter

How to Use the SQL select LIKE Parameter

Similar operations use the WHERE clause to search for a specific mode column.

Similar Operators
Similar carriers are used to search for the specified mode.

Favorite SQL syntax

SELECT column_name(s)FROM table_nameWHERE column_name LIKE pattern

For example, if you run like in the "person" table:

P_Id	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 select people to live in a city and start with "S" from the above table.

We use the following SELECT statement:

SELECT * FROM PersonsWHERE City LIKE 's%'

The '%' symbol can be used to define the pattern before and after a wildcard (missing mail mode.

The result set looks like this:

 
 

  
  
 
   
 
    
P_Id
 
    
LastName
 
    
FirstName
 
    
Address
 
    
City
 
   
 
   
 
    
1
 
    
Hansen
 
    
Ola
 
    
Timoteivn 10
 
    
Sandnes
 
   
 
   
 
    
2
 
    
Svendson
 
    
Tove
 
    
Borgvn 23
 
    
Sandnes
 
   
 
   
 
    
3
 
    
Pettersen
 
    
Kari
 
    
Storgt 20
 
    
Stavanger
 
   
 
  
 
 
Next, we want to select people to live in a city, and the last "S" takes a seat from "person.

We use the following SELECT statement:
SELECT * FROM PersonsWHERE City LIKE '%s'
  
  

   
   
 
    
 
     
P_Id
 
     
LastName
 
     
FirstName
 
     
Address
 
     
City
 
    
 
    
 
     
1
 
     
Hansen
 
     
Ola
 
     
Timoteivn 10
 
     
Sandnes
 
    
 
    
 
     
2
 
     
Svendson
 
     
Tove
 
     
Borgvn 23
 
     
Sandnes
 
    
 
   
  
  
 
Next, we want to select people to live in a city, including "people" in the pattern of "tomato infertility.

We use the following SELECT statement:
SELECT * FROM PersonsWHERE City LIKE '%tav%'
   
   

    
    
 
     
 
      
_Id
 
      
LastName
 
      
FirstName
 
      
Address
 
      
City
 
     
 
     
 
      
3
 
      
Pettersen
 
      
Kari
 
      
Storgt 20
 
      
Stavanger
 
     
 
    
   
   
 
It is also possible that the selected person lives in a city and does not include the "man" table in the pattern "tomato infertility" by using the non-keyword.

We use the following SELECT statement:
SELECT * FROM PersonsWHERE City NOT LIKE '%tav%'
 
    
    

     
     
 
      
 
       
_Id
 
       
LastName
 
       
FirstName
 
       
Address
 
       
City
 
      
 
      
 
       
1
 
       
Hansen
 
       
Ola
 
       
Timoteivn 10
 
       
Sandnes
 
      
 
      
 
       
2
 
       
Svendson
 
       
Tove
 
       
Borgvn 23
 
       
Sandnes
 
      
 
     
    
    
 
Note: For reprint, please indicate that it is from www.111cn.cn/database/database.html