BINARY not recognized ??

From: Date: Sun, 04 Jan 2004 18:48:56 +0000
Subject: BINARY not recognized ??
Groups: php.db 
Request: Send a blank email to php-db+get-32263@lists.php.net to get a copy of this message
Hi. My server has MySQL 3.23.58 installed, and I just migrated over from RedHat 7.2 to ES 3.0. Previously I was using the BINARY command to execute a case-sensitive search for member user names like this: SELECT * FROM mem WHERE BINARY user_name = 'SomeOne'; I now get an error from MySQL stating that "BINARYuser_name" is not a valid column. So, something seems to be broken. I looked through the MySQL online docs and BINARY is still there, but, it won't work for me. Anyone have the same problem or know why BINARY won't work anymore? There seems to be no other way to do simple case-sensitive string comparisons directly in MySQL. Thanks!

« previous php.db (#32263) next »