On 22 May 2002, at 14:52, Richard Bolen wrote: > Is there any way via a SQL query to force case sensitivity to be > used for a non-binary char field? i.e.: for comparing strings in a > case sensitive way.
SELECT * FROM users WHERE BINARY password = 'cAsE_MAttErS'; http://www.mysql.com/doc/C/a/Case_Sensitivity_Operators.html -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- 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