Ach. I was misreading the original message the entire time.
The reason you see the behavior below for the second query is that
the comparisons are done without regard for trailing spaces.
If you change the column type to TEXT, the second query will
return nothing. (On the other hand, another effect is that values
stored in the column will *not* have trailing spaces stripped.)
At 15:06 -0600 11/27/02, [EMAIL PROTECTED] wrote:
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
