2
create table �����Ѹ� (�Ѹ� text, ʬ�ॳ���� varchar, ����1A���� char(16));
3
create index �����Ѹ�index1 on �����Ѹ� using btree (�Ѹ�);
4
create index �����Ѹ�index2 on �����Ѹ� using hash (ʬ�ॳ����);
5
insert into �����Ѹ� values('����ԥ塼���ǥ����ץ쥤','��A01��');
6
insert into �����Ѹ� values('����ԥ塼������ե��å���','ʬB10��');
7
insert into �����Ѹ� values('����ԥ塼���ץ�����ޡ�','��Z01��');
9
select * from �����Ѹ�;
10
select * from �����Ѹ� where ʬ�ॳ���� = '��Z01��';
11
select * from �����Ѹ� where ʬ�ॳ���� ~* '��z01��';
12
select * from �����Ѹ� where ʬ�ॳ���� like '_Z01_';
13
select * from �����Ѹ� where ʬ�ॳ���� like '_Z%';
14
select * from �����Ѹ� where �Ѹ� ~ '����ԥ塼��[�ǥ�]';
15
select * from �����Ѹ� where �Ѹ� ~* '����ԥ塼��[�ǥ�]';
16
select *,character_length(�Ѹ�) from �����Ѹ�;
17
select *,octet_length(�Ѹ�) from �����Ѹ�;
18
select *,position('��' in �Ѹ�) from �����Ѹ�;
19
select *,substring(�Ѹ� from 10 for 4) from �����Ѹ�;