1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
drop table ŒÆËã»úÊõÓï;
create table ŒÆËã»úÊõÓï(ÊõÓï text, ·ÖÀàºÅ varchar, ±ž×¢1A char(16));
create index ŒÆËã»úÊõÓïindex1 on ŒÆËã»úÊõÓï using btree(ÊõÓï);
create index ŒÆËã»úÊõÓïindex2 on ŒÆËã»úÊõÓï using btree(·ÖÀàºÅ);
insert into ŒÆËã»úÊõÓï values('µçÄÔÏÔÊŸÆÁ','»úA01ÉÏ');
insert into ŒÆËã»úÊõÓï values('µçÄÔÍŒÐÎ','·ÖB01ÖÐ');
insert into ŒÆËã»úÊõÓï values('µçÄÔ³ÌÐòÔ±','ÈËZ01ÏÂ');
vacuum ŒÆËã»úÊõÓï;
select * from ŒÆËã»úÊõÓï;
select * from ŒÆËã»úÊõÓï where ·ÖÀàºÅ = 'ÈËZ01ÏÂ';
select * from ŒÆËã»úÊõÓï where ·ÖÀàºÅ ~* 'ÈËz01ÏÂ';
select * from ŒÆËã»úÊõÓï where ·ÖÀàºÅ like '_Z01_';
select * from ŒÆËã»úÊõÓï where ·ÖÀàºÅ like '_Z%';
select * from ŒÆËã»úÊõÓï where ÊõÓï ~ 'µçÄÔ[ÏÔÍŒ]';
select * from ŒÆËã»úÊõÓï where ÊõÓï ~* 'µçÄÔ[ÏÔÍŒ]';
select *,character_length(ÊõÓï) from ŒÆËã»úÊõÓï;
select *,octet_length(ÊõÓï) from ŒÆËã»úÊõÓï;
select *,position('ÏÔ' in ÊõÓï) from ŒÆËã»úÊõÓï;
select *,substring(ÊõÓï from 3 for 4) from ŒÆËã»úÊõÓï;
|