Query returning the wrong result

[devendra katiyar]

Hi All ,



I am using mysql data for our project .

see the below query when i try to find the the user information by USER_ID ,USER_IS is auto generated column , in query it does not match the actual user of USER_ID still it return the value .

SELECT USER_ID,EXTERNAL_ID FROM USER WHERE USER_ID='[e-mail]';
+------------+------------------+
| USER_ID | EXTERNAL_ID |
+------------+------------------+
| 0000000078 | [e-mail] |
+------------+------------------+
1 row in set, 1 warning (0.00 sec)


can any one explain me why this is happening ,how can i fix this problem


Please help me

Thanks All .

Devendra