case sensitive match in mysql ...

admin

Administrator
Staff member
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 ....
 
Back
Top