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, [EMAIL PROTECTED] 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) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
