谢邀。
你好。确认你的 MySQL 版本是多少?我在 5.7.22-log 版本下测试没有问题哦。
mysql> CREATE TABLE t_user(account varchar(20), password varchar(20), username varchar(20));
Query OK, 0 rows affected (0.20 sec)
mysql> INSERT INTO t_user values('似懂非懂', 'df', '十多个电饭锅');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO t_user values('你好', 'DF', '你好先生');
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM t_user WHERE password REGEXP '[d]';
+--------------+----------+--------------------+
| account | password | username |
+--------------+----------+--------------------+
| 似懂非懂 | df | 十多个电饭锅 |
| 你好 | DF | 你好先生 |
+--------------+----------+--------------------+
2 rows in set (0.01 sec)
mysql> SELECT * FROM t_user WHERE password REGEXP BINARY '[d]';
+--------------+----------+--------------------+
| account | password | username |
+--------------+----------+--------------------+
| 似懂非懂 | df | 十多个电饭锅 |
+--------------+----------+--------------------+
1 row in set (0.02 sec)
mysql> SELECT version();
+------------+
| version() |
+------------+
| 5.7.22-log |
+------------+
1 row in set (0.03 sec)
祝好。