Re: Checking for exact match in row

[Hartmut Holzgraefe]

cameron stevenson Wrote:
-------------------------------------------------------
> @Hartmut: the Varchar for username is 20

hm ... what mysql version?

and can you try to create a short reproducible example
showing the problem? Just the CREATE TABLE statement,
a few INSERT statements and a SELECT showing the
unexpected results?

Knowing the servers character set settings may also
help, you can check these with "SHOW VARIABLES LIKE
'%char%';" and "SHOW VARIABLES LIKE '%collat%';"

--
Hartmut Holzgraefe, MySQL Regional Support Manager EMEA

Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering