SQL 에서 WHERE 절 이용시..

mysql> use test
Database changed
mysql> CREATE TABLE test (
-> no INT(10) NOT NULL AUTO_INCREMENT,
-> category TINYTEXT NOT NULL,
-> statement TINYTEXT NOT NULL,
-> korean TINYTEXT NOT NULL,
-> path TINYTEXT NOT NULL,
-> PRIMARY KEY (no) );
Query OK, 0 rows affected (0.00 sec)

mysql> insert into test values ('', 'c1', 'statement', 'korean?', '/home/' );
Query OK, 1 row affected (0.00 sec)

mysql> select * from test where no = 1;
+----+----------+-----------+---------+--------+
| no | category | statement | korean | path |
+----+----------+-----------+---------+--------+
| 1 | c1 | statement | korean? | /home/ |
+----+----------+-----------+---------+--------+
1 row in set (0.00 sec)

mysql> select * from test where korean = 'korean';
Empty set (0.00 sec)

mysql> select * from test where korean = 'korean?';
+----+----------+-----------+---------+--------+
| no | category | statement | korean | path |
+----+----------+-----------+---------+--------+
| 1 | c1 | statement | korean? | /home/ |
+----+----------+-----------+---------+--------+
1 row in set (0.00 sec)

mysql> select * from test where korean = 'korean%';
Empty set (0.00 sec)

mysql> select * from test where korean = 'korean%';
Empty set (0.00 sec)

mysql> select * from test where korean = 'korea%';
Empty set (0.00 sec)

mysql> select * from test where korean = '%rea%';
Empty set (0.00 sec)

mysql> select * from test where korean like '%rea%';
+----+----------+-----------+---------+--------+
| no | category | statement | korean | path |
+----+----------+-----------+---------+--------+
| 1 | c1 | statement | korean? | /home/ |
+----+----------+-----------+---------+--------+
1 row in set (0.00 sec)

mysql>
mysql> select * from test where korean like 'rea%';
Empty set (0.00 sec)

mysql> select * from test where korean like 'korea%';
+----+----------+-----------+---------+--------+
| no | category | statement | korean | path |
+----+----------+-----------+---------+--------+
| 1 | c1 | statement | korean? | /home/ |
+----+----------+-----------+---------+--------+
1 row in set (0.00 sec)

mysql> insert into test values ('', 'c1', 'statement', '한국인인가?', '/home/' );
Query OK, 1 row affected (0.00 sec)

mysql> select * from test where korean like '한국%'; +----+----------+-----------+------------------+--------+
| no | category | statement | korean | path |
+----+----------+-----------+------------------+--------+
| 2 | c1 | statement | 한국인인가? | /home/ |
+----+----------+-----------+------------------+--------+
1 row in set (0.00 sec)

mysql>