member varchar(16) NOT NULL default '',
PRIMARY KEY (member),
On Wed, Nov 27, 2002 at 03:28:15PM -0600, Paul DuBois wrote:
> 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)
