At 14:48 -0600 11/27/02, johnt@stripped wrote:
>Why? (Note the extra space after "me" in the second select)
Hardly enough information to go on. Apparently you're using a
column type like BLOB or TEXT for which trailing spaces are not
removed?
>
>Your MySQL connection id is 6021 to server version: 3.23.41-log
>
>mysql> select contact from options where member='me';
>+---------+
>| contact |
>+---------+
>| me |
>+---------+
>1 row in set (0.00 sec)
>
>mysql> select contact from options where member='me ';
>+---------+
>| contact |
>+---------+
>| me |
>+---------+
>1 row in set (0.00 sec)