2
create table ��ٸ���� (����ɱ text, ��Ƴ��� varchar, ���� varchar(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Ħ');
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 ��Ƴ��� ~* '����[��ش��]';
17
select *, character_length(����ɱ) from ��ٸ����;
18
select *, octet_length(����ɱ) from ��ٸ����;
19
select *, position('ȴ��' in ��Ƴ���) from ��ٸ����;
20
select *, substring(��Ƴ��� from 3 for 6 ) from ��ٸ����;