SELECT * FROM paper WHERE paper_name LIKE '人人网';
SELECT * FROM paper WHERE paper_name LIKE '%人人网';
SELECT * FROM paper WHERE paper_name LIKE '人人网%';
SELECT * FROM paper WHERE paper_name LIKE '%人人网%';
"%" 可用于定义通配符(模式中缺少的字母)。
'%-%' 前后可以有无数个字符
这道题你会答吗?花几分钟告诉大家答案吧!
扫描二维码,关注牛客网
下载牛客APP,随时随地刷题