% 代表0或多个字符
_ 代表单个字符
like_ _,表示两个字符的串
%china%表示带有china 子串的串
一个利用like的例子
create table prod(
id varchar2(10)primary key,
color varchar2(10),
amount number
)
insert into prod values('P001','红',124);
insert into prod values('P002','黄',34);
insert into prod values('P003','红',null);
insert into prod values('M004','蓝',890);
insert into prod values('M005','白',14);
insert into prod values('P006','红',345);
insert into prod values('L007','蓝',23);
insert into prod values('L008','绿',323);
insert into prod values('P009','紫',234);
选出所有以P打头的产品
select * from prod
where id like 'p%';