like % 模糊匹配查询

SELECT *
FROM  titles
WHERE title like '%computer%'  --title含有computer字样的就满足
 


like  %   //title书名含s字样
SELECT  *
FROM  titles
WHERE title like '%s%'  ----title含有s字样的就满足

 

SELECT au_lname
FROM authors
WHERE au_lname  like '%s'    //au_lname字母s结尾满足 
 

SELECT au_lname
FROM authors
WHERE au_lname  like 's%'     // 字母s开头
 

like % -----不含computer
SELECT *
FROM  titles
WHERE title  not like '%computer%'
 



like _      //_限定一个字符，一个_表示一个字符，2个__表示两个字符

select *
from authors
//含有nn的，且只含一个
SELECT  au_fname, au_lname    
FROM authors
WHERE au_fname like '_nn'
 


SELECT  au_fname, au_lname
FROM authors
WHERE au_fname like '_h_n'

SELECT  *
FROM authors
WHERE au_id like '721-____-____'




like []      //括号中限定范围

SELECT  au_fname, au_lname
FROM authors
WHERE au_fname like '[a-h]hery'