hi!
can some one tell me how do i do a case sensitive match in mysql ....
eg: column name = userid;
value = <!-- m --><a class="postlink" href="http://www.phpbuilder.com/board/archive/index.php/">http://www.phpbuilder.com/board/archive/index.php/</a><!-- m -->"DANNY";
column name = usercode;
value = 100;
if i say ...
select usercode from usertab where userid='danny';
this query returs true .. i,e(usercode=100)
where as i want this to return false ... i,e case sensitive match ...
can some one tell me how to do it ...
thanks,
danny ....
can some one tell me how do i do a case sensitive match in mysql ....
eg: column name = userid;
value = <!-- m --><a class="postlink" href="http://www.phpbuilder.com/board/archive/index.php/">http://www.phpbuilder.com/board/archive/index.php/</a><!-- m -->"DANNY";
column name = usercode;
value = 100;
if i say ...
select usercode from usertab where userid='danny';
this query returs true .. i,e(usercode=100)
where as i want this to return false ... i,e case sensitive match ...
can some one tell me how to do it ...
thanks,
danny ....