summaryrefslogtreecommitdiff
path: root/mysql-test/suite/jp/r/jp_like_sjis.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/jp/r/jp_like_sjis.result')
-rwxr-xr-xmysql-test/suite/jp/r/jp_like_sjis.result322
1 files changed, 322 insertions, 0 deletions
diff --git a/mysql-test/suite/jp/r/jp_like_sjis.result b/mysql-test/suite/jp/r/jp_like_sjis.result
new file mode 100755
index 00000000000..a8145fb08f0
--- /dev/null
+++ b/mysql-test/suite/jp/r/jp_like_sjis.result
@@ -0,0 +1,322 @@
+drop table if exists `‚s‚P`;
+drop table if exists `‚s‚Q`;
+drop table if exists `‚s‚R`;
+drop table if exists `‚s‚S`;
+drop table if exists `‚s‚T`;
+drop table if exists `‚s‚U`;
+drop table if exists `‚s‚V`;
+drop table if exists `‚s‚W`;
+drop table if exists `‚s‚X`;
+drop table if exists `‚s‚P‚O`;
+drop table if exists `‚s‚P‚P`;
+drop table if exists `‚s‚P‚Q`;
+SET NAMES sjis;
+SET character_set_database = sjis;
+CREATE TABLE `‚s‚P` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
+CREATE TABLE `‚s‚Q` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
+CREATE TABLE `‚s‚R` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
+CREATE TABLE `‚s‚S` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
+CREATE TABLE `‚s‚T` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
+CREATE TABLE `‚s‚U` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
+CREATE TABLE `‚s‚V` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = heap;
+CREATE TABLE `‚s‚W` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = heap;
+CREATE TABLE `‚s‚X` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = heap;
+CREATE TABLE `‚s‚P‚O` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = bdb;
+CREATE TABLE `‚s‚P‚P` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = bdb;
+CREATE TABLE `‚s‚P‚Q` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = bdb;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚P`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚Q`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚R`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚S`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚T`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚U`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚V`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚W`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚X`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚P‚O`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚P‚P`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚P‚Q`;
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE ' %';
+‚b‚P
+ !"#$%&'()*+,-./
+ ¡¢£¤¥¦§¨©ª«¬­®¯
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '% %';
+‚b‚P
+ !"#$%&'()*+,-./
+ ¡¢£¤¥¦§¨©ª«¬­®¯
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '% ';
+‚b‚P
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE 'À%';
+‚b‚P
+ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '%×Ø%';
+‚b‚P
+ĞÑÒÓÔÕÖ×ØÙÚÛÜİŞß
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '%¿';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '°±²³´µ¶·¸¹º»¼½¾¿%';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿%';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '@%';
+‚b‚P
+@@ABCDEFGHIJKLMNOPQR
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%@%';
+‚b‚P
+@@ABCDEFGHIJKLMNOPQR
+EEğñòóôõö÷EEEEüEEEE@
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%@';
+‚b‚P
+EEğñòóôõö÷EEEEüEEEE@
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '‚Æ%';
+‚b‚P
+‚ƂǂȂɂʂ˂̂͂΂ςЂт҂ӂԂՂւׂ؂Ù
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%‚ %';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%‚í';
+‚b‚P
+‚Ú‚Û‚Ü‚İ‚Ş‚ß‚à‚á‚â‚ã‚ä‚å‚æ‚ç‚è‚é‚ê‚ë‚ì‚í
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE 'E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±%';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±%';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE 'ƒ\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE '%–\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE '%\';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE 'ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE ' %';
+‚b‚P
+ !"#$%&'()*+,-./
+ ¡¢£¤¥¦§¨©ª«¬­®¯
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '% %';
+‚b‚P
+ !"#$%&'()*+,-./
+ ¡¢£¤¥¦§¨©ª«¬­®¯
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '% ';
+‚b‚P
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE 'À%';
+‚b‚P
+ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '%×Ø%';
+‚b‚P
+ĞÑÒÓÔÕÖ×ØÙÚÛÜİŞß
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '%¿';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '°±²³´µ¶·¸¹º»¼½¾¿%';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿%';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '@%';
+‚b‚P
+@@ABCDEFGHIJKLMNOPQR
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%@%';
+‚b‚P
+@@ABCDEFGHIJKLMNOPQR
+EEğñòóôõö÷EEEEüEEEE@
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%@';
+‚b‚P
+EEğñòóôõö÷EEEEüEEEE@
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '‚Æ%';
+‚b‚P
+‚ƂǂȂɂʂ˂̂͂΂ςЂт҂ӂԂՂւׂ؂Ù
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%‚ %';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%‚í';
+‚b‚P
+‚Ú‚Û‚Ü‚İ‚Ş‚ß‚à‚á‚â‚ã‚ä‚å‚æ‚ç‚è‚é‚ê‚ë‚ì‚í
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE 'E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±%';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±%';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE 'ƒ\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE '%–\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE '%\';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE 'ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE ' %';
+‚b‚P
+ !"#$%&'()*+,-./
+ ¡¢£¤¥¦§¨©ª«¬­®¯
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '% %';
+‚b‚P
+ !"#$%&'()*+,-./
+ ¡¢£¤¥¦§¨©ª«¬­®¯
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '% ';
+‚b‚P
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE 'À%';
+‚b‚P
+ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '%×Ø%';
+‚b‚P
+ĞÑÒÓÔÕÖ×ØÙÚÛÜİŞß
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '%¿';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '°±²³´µ¶·¸¹º»¼½¾¿%';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿%';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '@%';
+‚b‚P
+@@ABCDEFGHIJKLMNOPQR
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%@%';
+‚b‚P
+@@ABCDEFGHIJKLMNOPQR
+EEğñòóôõö÷EEEEüEEEE@
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%@';
+‚b‚P
+EEğñòóôõö÷EEEEüEEEE@
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '‚Æ%';
+‚b‚P
+‚ƂǂȂɂʂ˂̂͂΂ςЂт҂ӂԂՂւׂ؂Ù
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%‚ %';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%‚í';
+‚b‚P
+‚Ú‚Û‚Ü‚İ‚Ş‚ß‚à‚á‚â‚ã‚ä‚å‚æ‚ç‚è‚é‚ê‚ë‚ì‚í
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE 'E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±%';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±%';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE 'ƒ\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE '%–\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE '%\';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE 'ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE ' %';
+‚b‚P
+ !"#$%&'()*+,-./
+ ¡¢£¤¥¦§¨©ª«¬­®¯
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE '% %';
+‚b‚P
+ !"#$%&'()*+,-./
+ ¡¢£¤¥¦§¨©ª«¬­®¯
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE '% ';
+‚b‚P
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE 'À%';
+‚b‚P
+ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE '%×Ø%';
+‚b‚P
+ĞÑÒÓÔÕÖ×ØÙÚÛÜİŞß
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE '%¿';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿';
+‚b‚P
+°±²³´µ¶·¸¹º»¼½¾¿
+SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '@%';
+‚b‚P
+@@ABCDEFGHIJKLMNOPQR
+SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '%@%';
+‚b‚P
+@@ABCDEFGHIJKLMNOPQR
+EEğñòóôõö÷EEEEüEEEE@
+SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '%@';
+‚b‚P
+EEğñòóôõö÷EEEEüEEEE@
+SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '‚Æ%';
+‚b‚P
+‚ƂǂȂɂʂ˂̂͂΂ςЂт҂ӂԂՂւׂ؂Ù
+SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '%‚ %';
+‚b‚P
+E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚­‚®‚¯‚°‚±
+SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '%‚í';
+‚b‚P
+‚Ú‚Û‚Ü‚İ‚Ş‚ß‚à‚á‚â‚ã‚ä‚å‚æ‚ç‚è‚é‚ê‚ë‚ì‚í
+SELECT * FROM `‚s‚P‚Q` WHERE `‚b‚P` LIKE 'ƒ\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚P‚Q` WHERE `‚b‚P` LIKE '%–\%';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+SELECT * FROM `‚s‚P‚Q` WHERE `‚b‚P` LIKE '%\';
+‚b‚P
+ƒ\\•\—\\‰\\\“\”\–\˜\‘\’\™\š\›\œ\\\
+DROP TABLE `‚s‚P`;
+DROP TABLE `‚s‚Q`;
+DROP TABLE `‚s‚R`;
+DROP TABLE `‚s‚S`;
+DROP TABLE `‚s‚T`;
+DROP TABLE `‚s‚U`;
+DROP TABLE `‚s‚V`;
+DROP TABLE `‚s‚W`;
+DROP TABLE `‚s‚X`;
+DROP TABLE `‚s‚P‚O`;
+DROP TABLE `‚s‚P‚P`;
+DROP TABLE `‚s‚P‚Q`;