Results 1 to 2 of 2
Jan 18, 2006, 05:58 #1
- Join Date
- Dec 2005
- 0 Post(s)
- 0 Thread(s)
How to make case sensitive string compare in MySql query ?
Hello all ,
i'm using MySql version 5.0.9
I want to compare with case sensitive in the query ,
my password has to be case sensitive , so i want to compare with case sensitive . does anyone have idea how to compare with case sensitive ?
STRCMP() function not support case sensitive ?
here is my procedure :
DROP PROCEDURE IF EXISTS `cms`.`sp_Login`$$
CREATE PROCEDURE `sp_Login`(
select 1 from t_account a where a.account_id = p_account_id and
a.password = p_password)
Jan 18, 2006, 08:00 #2
select 1 from t_account a where a.account_id = p_account_id and BINARY a.password = p_password)