mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
7ab1c8dc93
Bug#28563 Test suite "jp" fails completely
- The main goal of this fix is to make the "jp" suite runnable in general
and to make it more robust for use in pushbuild under build team conditions.
- It was decided to fix the remaining heavy issues within the
architecture of this test later
(-> WL 4327 Redesign the 'jp' testsuite for build team testing conditions)
Only the test jp_trim_sjis got some significant improvements of its
architecture (Just as proof of concept for the other tests).
- Tests suffering from
Bug 36597 Testsuite "jp": Suspicious results for some tests
(unexpected result sets)
were disabled
- *.opt files were used to avoid differences on OS (Windows) because of
case sensitive tablenames within the tests
mysql-test/suite/jp/r/jp_alter_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_alter_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_alter_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_alter_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_charlength_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_charlength_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_charlength_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_charlength_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_charset_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_charset_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_charset_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_charset_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_convert_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_convert_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_convert_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_convert_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_create_db_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_create_db_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_create_db_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_create_db_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_create_tbl_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_create_tbl_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_create_tbl_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_create_tbl_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_enum_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_enum_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_enum_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_enum_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_insert_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_insert_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_insert_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_insert_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_instr_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_instr_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_instr_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_instr_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_join_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_join_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_join_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_join_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_left_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_left_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_left_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_left_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_length_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_length_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_length_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_length_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_like_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_like_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_like_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_like_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_locate_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_locate_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_locate_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_locate_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_lpad_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_lpad_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_lpad_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_lpad_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_ltrim_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_ltrim_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_ltrim_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_ltrim_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_ps_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_ps_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_replace_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_replace_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_replace_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_replace_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_reverse_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_reverse_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_reverse_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_reverse_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_right_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_right_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_right_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_right_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_rpad_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_rpad_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_rpad_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_rpad_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_rtrim_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_rtrim_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_rtrim_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_rtrim_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_select_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_select_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_select_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_select_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_subquery_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_subquery_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_subquery_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_subquery_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_substring_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_substring_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_substring_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_substring_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_trim_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_trim_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_trim_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_trim_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_union_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_update_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_update_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_update_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_update_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_where_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_where_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_where_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_where_utf8.result:
Updated results
mysql-test/suite/jp/t/jp_alter_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_alter_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_alter_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_alter_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_charlength_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_charlength_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_charlength_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_charlength_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_charset_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_charset_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_charset_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_charset_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_convert_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_convert_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_convert_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_convert_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_create_db_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_create_db_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_create_tbl_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_create_tbl_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_create_tbl_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_create_tbl_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_enum_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_enum_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_enum_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_enum_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_insert_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_insert_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_insert_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_insert_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_instr_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_instr_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_instr_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_instr_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_join_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_join_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_join_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_join_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_left_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_left_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_left_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_left_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_length_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_length_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_length_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_length_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_like_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_like_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_like_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_like_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_locate_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_locate_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_locate_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_locate_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_lpad_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_lpad_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_lpad_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_lpad_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_ltrim_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_ltrim_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_ltrim_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_ltrim_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_ps_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_ps_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_replace_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_replace_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_replace_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_replace_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_reverse_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_reverse_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_reverse_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_reverse_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_right_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_right_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_right_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_right_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_rpad_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_rpad_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_rpad_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_rpad_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_rtrim_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_rtrim_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_rtrim_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_rtrim_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_select_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_select_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_select_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_select_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_subquery_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_subquery_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_subquery_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_subquery_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_substring_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_substring_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_substring_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_substring_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_trim_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_trim_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_trim_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_trim_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_union_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_update_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_update_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_update_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_update_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_where_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_where_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_where_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_where_utf8.test:
Updated results
mysql-test/suite/jp/include/trim_sjis.inc:
Auxiliary script
mysql-test/suite/jp/t/disabled.def:
Disable tests which suffer to an unacceptable extend
from bug 36597 Testsuite "jp": Suspicious results for some tests
260 lines
9.9 KiB
Text
260 lines
9.9 KiB
Text
drop table if exists `£Ô£±`;
|
||
drop table if exists `£Ô£²`;
|
||
drop table if exists `£Ô£³`;
|
||
drop table if exists `£Ô£´`;
|
||
drop table if exists `£Ô£µ`;
|
||
drop table if exists `£Ô£¶`;
|
||
drop table if exists `£Ô£·`;
|
||
drop table if exists `£Ô£¸`;
|
||
drop table if exists `£Ô£¹`;
|
||
SET NAMES ujis;
|
||
SET character_set_database = ujis;
|
||
CREATE TABLE `£Ô£±` (`£Ã£±` char(20), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
|
||
CREATE TABLE `£Ô£²` (`£Ã£±` char(20), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
|
||
CREATE TABLE `£Ô£³` (`£Ã£±` char(20), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
|
||
CREATE TABLE `£Ô£´` (`£Ã£±` char(20), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;
|
||
CREATE TABLE `£Ô£µ` (`£Ã£±` char(20), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;
|
||
CREATE TABLE `£Ô£¶` (`£Ã£±` char(20), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;
|
||
CREATE TABLE `£Ô£·` (`£Ã£±` char(20), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MEMORY;
|
||
CREATE TABLE `£Ô£¸` (`£Ã£±` char(20), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MEMORY;
|
||
CREATE TABLE `£Ô£¹` (`£Ã£±` char(20), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MEMORY;
|
||
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `£Ô£±`;
|
||
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `£Ô£²`;
|
||
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `£Ô£³`;
|
||
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `£Ô£´`;
|
||
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `£Ô£µ`;
|
||
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `£Ô£¶`;
|
||
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `£Ô£·`;
|
||
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `£Ô£¸`;
|
||
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `£Ô£¹`;
|
||
SELECT * FROM `£Ô£±` WHERE `£Ã£±` LIKE ' %';
|
||
£Ã£±
|
||
!"#$%&'()*+,-./
|
||
Ž¡Ž¢Ž£Ž¤Ž¥Ž¦Ž§Ž¨Ž©ŽªŽ«Ž¬ŽŽ®Ž¯
|
||
SELECT * FROM `£Ô£±` WHERE `£Ã£±` LIKE '% %';
|
||
£Ã£±
|
||
!"#$%&'()*+,-./
|
||
Ž¡Ž¢Ž£Ž¤Ž¥Ž¦Ž§Ž¨Ž©ŽªŽ«Ž¬ŽŽ®Ž¯
|
||
SELECT * FROM `£Ô£±` WHERE `£Ã£±` LIKE '% ';
|
||
£Ã£±
|
||
SELECT * FROM `£Ô£±` WHERE `£Ã£±` LIKE 'ŽÀ%';
|
||
£Ã£±
|
||
ŽÀŽÁŽÂŽÃŽÄŽÅŽÆŽÇŽÈŽÉŽÊŽËŽÌŽÍŽÎŽÏ
|
||
SELECT * FROM `£Ô£±` WHERE `£Ã£±` LIKE '%Ž×ŽØ%';
|
||
£Ã£±
|
||
ŽÐŽÑŽÒŽÓŽÔŽÕŽÖŽ×ŽØŽÙŽÚŽÛŽÜŽÝŽÞŽß
|
||
SELECT * FROM `£Ô£±` WHERE `£Ã£±` LIKE '%Ž¿';
|
||
£Ã£±
|
||
Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿
|
||
SELECT * FROM `£Ô£±` WHERE `£Ã£±` LIKE 'Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿%';
|
||
£Ã£±
|
||
Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿
|
||
SELECT * FROM `£Ô£±` WHERE `£Ã£±` LIKE '%Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿%';
|
||
£Ã£±
|
||
Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿
|
||
SELECT * FROM `£Ô£±` WHERE `£Ã£±` LIKE '%Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿';
|
||
£Ã£±
|
||
Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿
|
||
SELECT * FROM `£Ô£²` WHERE `£Ã£±` LIKE '¡¡%';
|
||
£Ã£±
|
||
¡¡¡¡¡¢¡£¡¤¡¥¡¦¡§¡¨¡©¡ª¡«¡¬¡¡®¡¯¡°¡±¡²¡³
|
||
SELECT * FROM `£Ô£²` WHERE `£Ã£±` LIKE '%¡¡%';
|
||
£Ã£±
|
||
¡¡¡¡¡¢¡£¡¤¡¥¡¦¡§¡¨¡©¡ª¡«¡¬¡¡®¡¯¡°¡±¡²¡³
|
||
¡¦¡¦¢ò¢ó¢ô¢õ¢ö¢÷¢ø¢ù¡¦¡¦¡¦¡¦¢þ¡¦¡¦¡¦¡¦¡¡
|
||
SELECT * FROM `£Ô£²` WHERE `£Ã£±` LIKE '%¡¡';
|
||
£Ã£±
|
||
¡¦¡¦¢ò¢ó¢ô¢õ¢ö¢÷¢ø¢ù¡¦¡¦¡¦¡¦¢þ¡¦¡¦¡¦¡¦¡¡
|
||
SELECT * FROM `£Ô£²` WHERE `£Ã£±` LIKE '¤È%';
|
||
£Ã£±
|
||
¤È¤É¤Ê¤Ë¤Ì¤Í¤Î¤Ï¤Ð¤Ñ¤Ò¤Ó¤Ô¤Õ¤Ö¤×¤Ø¤Ù¤Ú¤Û
|
||
SELECT * FROM `£Ô£²` WHERE `£Ã£±` LIKE '%¤¢%';
|
||
£Ã£±
|
||
¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³
|
||
SELECT * FROM `£Ô£²` WHERE `£Ã£±` LIKE '%¤ï';
|
||
£Ã£±
|
||
¤Ü¤Ý¤Þ¤ß¤à¤á¤â¤ã¤ä¤å¤æ¤ç¤è¤é¤ê¤ë¤ì¤í¤î¤ï
|
||
SELECT * FROM `£Ô£²` WHERE `£Ã£±` LIKE '¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³%';
|
||
£Ã£±
|
||
¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³
|
||
SELECT * FROM `£Ô£²` WHERE `£Ã£±` LIKE '%¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³%';
|
||
£Ã£±
|
||
¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³
|
||
SELECT * FROM `£Ô£²` WHERE `£Ã£±` LIKE '%¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³';
|
||
£Ã£±
|
||
¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³
|
||
SELECT * FROM `£Ô£³` WHERE `£Ã£±` LIKE '<27>í´%';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£³` WHERE `£Ã£±` LIKE '%<25>í»%';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£³` WHERE `£Ã£±` LIKE '%<25>íÇ';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£³` WHERE `£Ã£±` LIKE '<27>í´<C3AD>íµ<C3AD>í¶<C3AD>í·<C3AD>í¸<C3AD>í¹<C3AD>íº<C3AD>í»<C3AD>í¼<C3AD>í½<C3AD>í¾<C3AD>í¿<C3AD>íÀ<C3AD>íÁ<C3AD>íÂ<C3AD>íÃ<C3AD>íÄ<C3AD>íÅ<C3AD>íÆ<C3AD>íÇ%';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£³` WHERE `£Ã£±` LIKE '%<25>í´<C3AD>íµ<C3AD>í¶<C3AD>í·<C3AD>í¸<C3AD>í¹<C3AD>íº<C3AD>í»<C3AD>í¼<C3AD>í½<C3AD>í¾<C3AD>í¿<C3AD>íÀ<C3AD>íÁ<C3AD>íÂ<C3AD>íÃ<C3AD>íÄ<C3AD>íÅ<C3AD>íÆ<C3AD>íÇ%';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£³` WHERE `£Ã£±` LIKE '%<25>í´<C3AD>íµ<C3AD>í¶<C3AD>í·<C3AD>í¸<C3AD>í¹<C3AD>íº<C3AD>í»<C3AD>í¼<C3AD>í½<C3AD>í¾<C3AD>í¿<C3AD>íÀ<C3AD>íÁ<C3AD>íÂ<C3AD>íÃ<C3AD>íÄ<C3AD>íÅ<C3AD>íÆ<C3AD>íÇ';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£´` WHERE `£Ã£±` LIKE ' %';
|
||
£Ã£±
|
||
!"#$%&'()*+,-./
|
||
Ž¡Ž¢Ž£Ž¤Ž¥Ž¦Ž§Ž¨Ž©ŽªŽ«Ž¬ŽŽ®Ž¯
|
||
SELECT * FROM `£Ô£´` WHERE `£Ã£±` LIKE '% %';
|
||
£Ã£±
|
||
!"#$%&'()*+,-./
|
||
Ž¡Ž¢Ž£Ž¤Ž¥Ž¦Ž§Ž¨Ž©ŽªŽ«Ž¬ŽŽ®Ž¯
|
||
SELECT * FROM `£Ô£´` WHERE `£Ã£±` LIKE '% ';
|
||
£Ã£±
|
||
SELECT * FROM `£Ô£´` WHERE `£Ã£±` LIKE 'ŽÀ%';
|
||
£Ã£±
|
||
ŽÀŽÁŽÂŽÃŽÄŽÅŽÆŽÇŽÈŽÉŽÊŽËŽÌŽÍŽÎŽÏ
|
||
SELECT * FROM `£Ô£´` WHERE `£Ã£±` LIKE '%Ž×ŽØ%';
|
||
£Ã£±
|
||
ŽÐŽÑŽÒŽÓŽÔŽÕŽÖŽ×ŽØŽÙŽÚŽÛŽÜŽÝŽÞŽß
|
||
SELECT * FROM `£Ô£´` WHERE `£Ã£±` LIKE '%Ž¿';
|
||
£Ã£±
|
||
Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿
|
||
SELECT * FROM `£Ô£´` WHERE `£Ã£±` LIKE 'Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿%';
|
||
£Ã£±
|
||
Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿
|
||
SELECT * FROM `£Ô£´` WHERE `£Ã£±` LIKE '%Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿%';
|
||
£Ã£±
|
||
Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿
|
||
SELECT * FROM `£Ô£´` WHERE `£Ã£±` LIKE '%Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿';
|
||
£Ã£±
|
||
Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿
|
||
SELECT * FROM `£Ô£µ` WHERE `£Ã£±` LIKE '¡¡%';
|
||
£Ã£±
|
||
¡¡¡¡¡¢¡£¡¤¡¥¡¦¡§¡¨¡©¡ª¡«¡¬¡¡®¡¯¡°¡±¡²¡³
|
||
SELECT * FROM `£Ô£µ` WHERE `£Ã£±` LIKE '%¡¡%';
|
||
£Ã£±
|
||
¡¡¡¡¡¢¡£¡¤¡¥¡¦¡§¡¨¡©¡ª¡«¡¬¡¡®¡¯¡°¡±¡²¡³
|
||
¡¦¡¦¢ò¢ó¢ô¢õ¢ö¢÷¢ø¢ù¡¦¡¦¡¦¡¦¢þ¡¦¡¦¡¦¡¦¡¡
|
||
SELECT * FROM `£Ô£µ` WHERE `£Ã£±` LIKE '%¡¡';
|
||
£Ã£±
|
||
¡¦¡¦¢ò¢ó¢ô¢õ¢ö¢÷¢ø¢ù¡¦¡¦¡¦¡¦¢þ¡¦¡¦¡¦¡¦¡¡
|
||
SELECT * FROM `£Ô£µ` WHERE `£Ã£±` LIKE '¤È%';
|
||
£Ã£±
|
||
¤È¤É¤Ê¤Ë¤Ì¤Í¤Î¤Ï¤Ð¤Ñ¤Ò¤Ó¤Ô¤Õ¤Ö¤×¤Ø¤Ù¤Ú¤Û
|
||
SELECT * FROM `£Ô£µ` WHERE `£Ã£±` LIKE '%¤¢%';
|
||
£Ã£±
|
||
¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³
|
||
SELECT * FROM `£Ô£µ` WHERE `£Ã£±` LIKE '%¤ï';
|
||
£Ã£±
|
||
¤Ü¤Ý¤Þ¤ß¤à¤á¤â¤ã¤ä¤å¤æ¤ç¤è¤é¤ê¤ë¤ì¤í¤î¤ï
|
||
SELECT * FROM `£Ô£µ` WHERE `£Ã£±` LIKE '¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³%';
|
||
£Ã£±
|
||
¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³
|
||
SELECT * FROM `£Ô£µ` WHERE `£Ã£±` LIKE '%¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³%';
|
||
£Ã£±
|
||
¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³
|
||
SELECT * FROM `£Ô£µ` WHERE `£Ã£±` LIKE '%¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³';
|
||
£Ã£±
|
||
¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³
|
||
SELECT * FROM `£Ô£¶` WHERE `£Ã£±` LIKE '<27>í´%';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£¶` WHERE `£Ã£±` LIKE '%<25>í»%';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£¶` WHERE `£Ã£±` LIKE '%<25>íÇ';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£¶` WHERE `£Ã£±` LIKE '<27>í´<C3AD>íµ<C3AD>í¶<C3AD>í·<C3AD>í¸<C3AD>í¹<C3AD>íº<C3AD>í»<C3AD>í¼<C3AD>í½<C3AD>í¾<C3AD>í¿<C3AD>íÀ<C3AD>íÁ<C3AD>íÂ<C3AD>íÃ<C3AD>íÄ<C3AD>íÅ<C3AD>íÆ<C3AD>íÇ%';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£¶` WHERE `£Ã£±` LIKE '%<25>í´<C3AD>íµ<C3AD>í¶<C3AD>í·<C3AD>í¸<C3AD>í¹<C3AD>íº<C3AD>í»<C3AD>í¼<C3AD>í½<C3AD>í¾<C3AD>í¿<C3AD>íÀ<C3AD>íÁ<C3AD>íÂ<C3AD>íÃ<C3AD>íÄ<C3AD>íÅ<C3AD>íÆ<C3AD>íÇ%';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£¶` WHERE `£Ã£±` LIKE '%<25>í´<C3AD>íµ<C3AD>í¶<C3AD>í·<C3AD>í¸<C3AD>í¹<C3AD>íº<C3AD>í»<C3AD>í¼<C3AD>í½<C3AD>í¾<C3AD>í¿<C3AD>íÀ<C3AD>íÁ<C3AD>íÂ<C3AD>íÃ<C3AD>íÄ<C3AD>íÅ<C3AD>íÆ<C3AD>íÇ';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£·` WHERE `£Ã£±` LIKE ' %';
|
||
£Ã£±
|
||
!"#$%&'()*+,-./
|
||
Ž¡Ž¢Ž£Ž¤Ž¥Ž¦Ž§Ž¨Ž©ŽªŽ«Ž¬ŽŽ®Ž¯
|
||
SELECT * FROM `£Ô£·` WHERE `£Ã£±` LIKE '% %';
|
||
£Ã£±
|
||
!"#$%&'()*+,-./
|
||
Ž¡Ž¢Ž£Ž¤Ž¥Ž¦Ž§Ž¨Ž©ŽªŽ«Ž¬ŽŽ®Ž¯
|
||
SELECT * FROM `£Ô£·` WHERE `£Ã£±` LIKE '% ';
|
||
£Ã£±
|
||
SELECT * FROM `£Ô£·` WHERE `£Ã£±` LIKE 'ŽÀ%';
|
||
£Ã£±
|
||
ŽÀŽÁŽÂŽÃŽÄŽÅŽÆŽÇŽÈŽÉŽÊŽËŽÌŽÍŽÎŽÏ
|
||
SELECT * FROM `£Ô£·` WHERE `£Ã£±` LIKE '%Ž×ŽØ%';
|
||
£Ã£±
|
||
ŽÐŽÑŽÒŽÓŽÔŽÕŽÖŽ×ŽØŽÙŽÚŽÛŽÜŽÝŽÞŽß
|
||
SELECT * FROM `£Ô£·` WHERE `£Ã£±` LIKE '%Ž¿';
|
||
£Ã£±
|
||
Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿
|
||
SELECT * FROM `£Ô£·` WHERE `£Ã£±` LIKE 'Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿%';
|
||
£Ã£±
|
||
Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿
|
||
SELECT * FROM `£Ô£·` WHERE `£Ã£±` LIKE '%Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿%';
|
||
£Ã£±
|
||
Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿
|
||
SELECT * FROM `£Ô£·` WHERE `£Ã£±` LIKE '%Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿';
|
||
£Ã£±
|
||
Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿
|
||
SELECT * FROM `£Ô£¸` WHERE `£Ã£±` LIKE '¡¡%';
|
||
£Ã£±
|
||
¡¡¡¡¡¢¡£¡¤¡¥¡¦¡§¡¨¡©¡ª¡«¡¬¡¡®¡¯¡°¡±¡²¡³
|
||
SELECT * FROM `£Ô£¸` WHERE `£Ã£±` LIKE '%¡¡%';
|
||
£Ã£±
|
||
¡¡¡¡¡¢¡£¡¤¡¥¡¦¡§¡¨¡©¡ª¡«¡¬¡¡®¡¯¡°¡±¡²¡³
|
||
¡¦¡¦¢ò¢ó¢ô¢õ¢ö¢÷¢ø¢ù¡¦¡¦¡¦¡¦¢þ¡¦¡¦¡¦¡¦¡¡
|
||
SELECT * FROM `£Ô£¸` WHERE `£Ã£±` LIKE '%¡¡';
|
||
£Ã£±
|
||
¡¦¡¦¢ò¢ó¢ô¢õ¢ö¢÷¢ø¢ù¡¦¡¦¡¦¡¦¢þ¡¦¡¦¡¦¡¦¡¡
|
||
SELECT * FROM `£Ô£¸` WHERE `£Ã£±` LIKE '¤È%';
|
||
£Ã£±
|
||
¤È¤É¤Ê¤Ë¤Ì¤Í¤Î¤Ï¤Ð¤Ñ¤Ò¤Ó¤Ô¤Õ¤Ö¤×¤Ø¤Ù¤Ú¤Û
|
||
SELECT * FROM `£Ô£¸` WHERE `£Ã£±` LIKE '%¤¢%';
|
||
£Ã£±
|
||
¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³
|
||
SELECT * FROM `£Ô£¸` WHERE `£Ã£±` LIKE '%¤ï';
|
||
£Ã£±
|
||
¤Ü¤Ý¤Þ¤ß¤à¤á¤â¤ã¤ä¤å¤æ¤ç¤è¤é¤ê¤ë¤ì¤í¤î¤ï
|
||
SELECT * FROM `£Ô£¸` WHERE `£Ã£±` LIKE '¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³%';
|
||
£Ã£±
|
||
¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³
|
||
SELECT * FROM `£Ô£¸` WHERE `£Ã£±` LIKE '%¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³%';
|
||
£Ã£±
|
||
¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³
|
||
SELECT * FROM `£Ô£¸` WHERE `£Ã£±` LIKE '%¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³';
|
||
£Ã£±
|
||
¡¦¤¡¤¢¤£¤¤¤¥¤¦¤§¤¨¤©¤ª¤«¤¬¤¤®¤¯¤°¤±¤²¤³
|
||
SELECT * FROM `£Ô£¹` WHERE `£Ã£±` LIKE '<27>í´%';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£¹` WHERE `£Ã£±` LIKE '%<25>í»%';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£¹` WHERE `£Ã£±` LIKE '%<25>íÇ';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£¹` WHERE `£Ã£±` LIKE '<27>í´<C3AD>íµ<C3AD>í¶<C3AD>í·<C3AD>í¸<C3AD>í¹<C3AD>íº<C3AD>í»<C3AD>í¼<C3AD>í½<C3AD>í¾<C3AD>í¿<C3AD>íÀ<C3AD>íÁ<C3AD>íÂ<C3AD>íÃ<C3AD>íÄ<C3AD>íÅ<C3AD>íÆ<C3AD>íÇ%';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£¹` WHERE `£Ã£±` LIKE '%<25>í´<C3AD>íµ<C3AD>í¶<C3AD>í·<C3AD>í¸<C3AD>í¹<C3AD>íº<C3AD>í»<C3AD>í¼<C3AD>í½<C3AD>í¾<C3AD>í¿<C3AD>íÀ<C3AD>íÁ<C3AD>íÂ<C3AD>íÃ<C3AD>íÄ<C3AD>íÅ<C3AD>íÆ<C3AD>íÇ%';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
SELECT * FROM `£Ô£¹` WHERE `£Ã£±` LIKE '%<25>í´<C3AD>íµ<C3AD>í¶<C3AD>í·<C3AD>í¸<C3AD>í¹<C3AD>íº<C3AD>í»<C3AD>í¼<C3AD>í½<C3AD>í¾<C3AD>í¿<C3AD>íÀ<C3AD>íÁ<C3AD>íÂ<C3AD>íÃ<C3AD>íÄ<C3AD>íÅ<C3AD>íÆ<C3AD>íÇ';
|
||
£Ã£±
|
||
<EFBFBD>í´<EFBFBD>íµ<EFBFBD>í¶<EFBFBD>í·<EFBFBD>í¸<EFBFBD>í¹<EFBFBD>íº<EFBFBD>í»<EFBFBD>í¼<EFBFBD>í½<EFBFBD>í¾<EFBFBD>í¿<EFBFBD>íÀ<EFBFBD>íÁ<EFBFBD>íÂ<EFBFBD>íÃ<EFBFBD>íÄ<EFBFBD>íÅ<EFBFBD>íÆ<EFBFBD>íÇ
|
||
DROP TABLE `£Ô£±`;
|
||
DROP TABLE `£Ô£²`;
|
||
DROP TABLE `£Ô£³`;
|
||
DROP TABLE `£Ô£´`;
|
||
DROP TABLE `£Ô£µ`;
|
||
DROP TABLE `£Ô£¶`;
|
||
DROP TABLE `£Ô£·`;
|
||
DROP TABLE `£Ô£¸`;
|
||
DROP TABLE `£Ô£¹`;
|