Question

oracle 如何查找特定字母开头的某个字段？

比如在teacher表中 有个teacher_no 字段，这个字段的值有的是 T20150101 有的是不带T的20150201。。 那么如何写SQL 语句找出所有的不是T开头的 选项呢？

Answer 1

1、创建测试表，

create table test_teacher(teacher_no varchar(30) , teacher_name varchar(30));

2、插入测试数据

insert into test_teacher values('T20150101','陈xx');

insert into test_teacher values('20150101','王xx');

insert into test_teacher values('T20150133','李xx');

insert into test_teacher values('20150122','朱xx');

insert into test_teacher values('T20150156','张xx');

insert into test_teacher values('T20150188','六xx');

commit;

3、查询表中全量数据，select t.* from test_teacher t;

4、编写sql，找出所有的不是T开头的记录; select t.*, rowid from test_teacher t where t.teacher_no not like 'T%';

Answer 2

select teacher_no from teacher

where teacher_no not like 'T%';

追问

这个我知道啊。。。问题是 现在需要的是 不以T开头的啊

追答

not like就是不以T开头了