mysql的select命令显示不全_为什么这条语句查询结果会显示不全？

mysql> SELECT DISTINCT username,password,email FROM t_u_e_p_csdn_net WHERE username LIKE 'sbboy' OR email LIKE 'sbboy@%';

+----------+----------+-------------------+

| username | password | email |

+----------+----------+-------------------+

|sbboy | 19890101 | sbsqqboy@163.com

+----------+----------+-------------------+

1 row in set (0.00 sec)

mysql> SELECT DISTINCT username,email,password FROM t_u_e_p_csdn_net WHERE username LIKE 'sbboy' OR email LIKE 'sbboy@%';

+----------+-------------------+----------+

| username | email | password |

+----------+-------------------+----------+

| 19890101 |sbsqqboy@163.com

+----------+-------------------+----------+

1 row in set (0.00 sec)

补充个表结构。。

t_u_e_p_csdn_net | CREATE TABLE `t_u_e_p_csdn_net` (

`id` int(8) NOT NULL AUTO_INCREMENT,

`username` varchar(30) NOT NULL DEFAULT '',

`email` varchar(32) NOT NULL DEFAULT '',

`password` varchar(32) NOT NULL DEFAULT '',

PRIMARY KEY (`id`),

KEY `email` (`email`),

KEY `username` (`username`) USING BTREE

) ENGINE=MyISAM AUTO_INCREMENT=12599950 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC

只是交换了一下password的位置，为何这两次查询的结果会是这个样子？

再次补充，不用DISTINCT也是这样的

mysql> SELECT username,password,email FROM t_u_e_p_csdn_net WHERE username LIKE

'sbboy' OR email LIKE 'sbboy@%';

+----------+----------+-------------------+

| username | password | email |

+----------+----------+-------------------+

|sbboy | 19890101 | sbsqqboy@163.com

+----------+----------+-------------------+

1 row in set (0.00 sec)

mysql> SELECT username,email,password FROM t_u_e_p_csdn_net WHERE username LIKE

'sbboy' OR email LIKE 'sbboy@%';

+----------+-------------------+----------+

| username | email | password |

+----------+-------------------+----------+

| 19890101 |sbsqqboy@163.com

+----------+-------------------+----------+

1 row in set (0.00 sec)

--------------------------------------------------------

再次补充 ，username = 也没用

mysql> SELECT DISTINCT username,email,password FROM t_u_e_p_csdn_net WHERE usern

ame = 'sbboy' OR email LIKE 'sbboy@%';

+----------+-------------------+----------+

| username | email | password |

+----------+-------------------+----------+

| 19890101 |sbsqqboy@163.com

+----------+-------------------+----------+

1 row in set (0.01 sec)

mysql> SELECT username,email,password FROM t_u_e_p_csdn_net WHERE username = 'sb

boy' OR email LIKE 'sbboy@%';

+----------+-------------------+----------+

| username | email | password |

+----------+-------------------+----------+

| 19890101 |sbsqqboy@163.com

+----------+-------------------+----------+

1 row in set (0.00 sec)