String MySQL

  1. Home
  2. MySQL
  3. String
  4. Using BINARY has the effect of causing [
ct.
mysql>
mysql>
mysql> SELECT 'a' REGEXP '[[:upper:]]', BINARY 'a' REGEXP '[[:upper:]]';
+--------------------------+---------------------------------+
| 'a' REGEXP '[[:upper:]]' | BINARY 'a' REGEXP '[[:upper:]]' |
+--------------------------+---------------------------------+
|                        1 |                               0 |
+--------------------------+---------------------------------+
1 row in set (0.00 sec)
mysql>
mysql>