mysql>
mysql> CREATE TABLE mytable
-> (
-> c CHAR(1)
-> );
Query OK, 0 rows affected (0.00 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>
mysql> SELECT c, c LIKE '\%', c LIKE '\_' FROM mytable;
+------+-------------+-------------+
| c | c LIKE '\%' | c LIKE '\_' |
+------+-------------+-------------+
| % | 1 | 0 |
| _ | 0 | 1 |
| . | 0 | 0 |
| ^ | 0 | 0 |
| $ | 0 | 0 |
| \ | 0 | 0 |
+------+-------------+-------------+
6 rows in set (0.00 sec)
mysql>
mysql> drop table mytable;
Query OK, 0 rows affected (0.00 sec)
mysql>