mysql>
mysql> CREATE TABLE mytable
-> (
-> c CHAR(1)
-> );
Query OK, 0 rows affected (0.01 sec)
mysql> INSERT INTO mytable (c)
-> VALUES
-> ('%'),
-> ('_'),
-> ('.'),
-> ('^'),
-> ('$'),
-> ('\\')
-> ;
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
mysql>
mysql> SELECT * FROM mytable;
+------+
| c |
+------+
| % |
| _ |
| . |
| ^ |
| $ |
| \ |
+------+
6 rows in set (0.00 sec)
mysql>
mysql> SELECT c, c LIKE '%', c LIKE '_' FROM mytable;
+------+------------+------------+
| c | c LIKE '%' | c LIKE '_' |
+------+------------+------------+
| % | 1 | 1 |
| _ | 1 | 1 |
| . | 1 | 1 |
| ^ | 1 | 1 |
| $ | 1 | 1 |
| \ | 1 | 1 |
+------+------------+------------+
6 rows in set (0.00 sec)
mysql>
mysql> drop table mytable;
Query OK, 0 rows affected (0.00 sec)
mysql>