2
create table �t�Ӹ�� (��~�O text, ���q���Y varchar, �a�} varchar(16));
3
create index �t�Ӹ��index1 on �t�Ӹ�� using btree (��~�O);
4
create index �t�Ӹ��index2 on �t�Ӹ�� using hash (���q���Y);
5
insert into �t�Ӹ�� values ('�q���~', '�F�F���', '�_A01��');
6
insert into �t�Ӹ�� values ('�s�y�~', '�]���������q', '��B10��');
7
insert into �t�Ӹ�� values ('�\���~', '�����ѥ��������q', '��Z01�E');
10
select * from �t�Ӹ�� where �a�} = '��Z01�E';
11
select * from �t�Ӹ�� where �a�} ~* '��z01�E';
12
select * from �t�Ӹ�� where �a�} like '_Z01_';
13
select * from �t�Ӹ�� where �a�} like '_Z%';
14
select * from �t�Ӹ�� where ���q���Y ~ '�F�F��[�H�O��]';
15
select * from �t�Ӹ�� where ���q���Y ~* '�F�F��[�H�O��]';
17
select *, character_length(��~�O) from �t�Ӹ��;
18
select *, octet_length(��~�O) from �t�Ӹ��;
19
select *, position('����' in ���q���Y) from �t�Ӹ��;
20
select *, substring(���q���Y from 3 for 6 ) from �t�Ӹ��;