How do I exclude rows in SQL where string does not contain two words-CodePudding

Home > other > How do I exclude rows in SQL where string does not contain two words

How do I exclude rows in SQL where string does not contain two words

Time：02-17

Example table to reproduce:

CREATE TABLE example
    (name varchar(200)
     
    );

INSERT INTO example
(name)
VALUES
('ab'),
('ab|test'),
('test');

SQL query:

select
name
from example
where name not like '


          
          
            Page link：https//www.codepudding.com/other/303555.html
          
          
               Prev:Distinct count of one column based on the lack of frequency of another with unique values
               Next:Three-table join with NO EXISTS


  
    
      
        
          
             Tags：  
sql               
        
      
    
  
 
    
      
        
        	
            	Related
            
                       
        
      
    
  

  
    
      
        
           Links：  
          CodePudding

            
      
    
  


  About Us:          Contact Us      Terms of Service      
Privacy Policy
  Copyright © 2010-2023，Powered By CodePudding