create table t1(a int,b varchar2(10));
insert into t1 values(1,'F');
insert into t1 values(2,' F');
insert into t1 values(3,'F ');
insert into t1 values(4,'');
insert into t1 values(5,NULL);
SELECT * FROM T1;
SELECT * FROM T1 WHERE B LIKE '%';
SELECT * FROM T1 WHERE B LIKE '%F%';
SELECT * FROM T1 WHERE B LIKE '%f%';
SELECT * FROM T1 WHERE B LIKE '%F';
SELECT * FROM T1 WHERE B LIKE '%F ';
SELECT * FROM T1 WHERE B LIKE 'F%';
SELECT * FROM T1 WHERE B LIKE ' F%';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28520410/viewspace-1261141/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
关闭 selinux
下一篇：
NULL 和 ''
请登录后发表评论
登录
全部评论
