How to differentiate data in SQL query

programming
1

Hi, I’m not expert for PHP but I’m able to make some working stuff. I have one table where are names of persons and other data. Until now I didn’t noticed that SQL doesn’t differentiate small and upper letters in table fields during SQL executing! :crying: So, if I have:


$fname='Lance';
$lname='Hall';
//make query
$query = "SELECT kl_name, kl_lastname, kl_level FROM clients WHERE kl_name = '$fname' and kl_lastname ='$lname' ";
$result=mysql_query($query);
...

it gave me same result if $fname is Lance or LANCE :m:!
Inside table CLIENTS are already rows where exists also Lance and LANCE.
Is there some way to make differentiate records according letter case and to be able to process only rows where $fname is Lance and other one when $fname is LANCE?
Thank you.