Re: small and big letter in WHERE statement
| From: | Angel Freire | Date: | Mon, 14 Jun 2004 08:28:19 +0000 |
| Subject: | Re: small and big letter in WHERE statement | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-188199@lists.php.net to get a copy of this message | ||
I'm guessing that you mean in a SQL sentence.
Well, depending on what SQL engine're you using it's case sensitive or
not.
MySQL don't take diferent case as diferent string, thats why is the
'binary' date type.
In that case you have two alternatives, or change the field type to
binary, or cast it in the where statement.
El lun, 14-06-2004 a las 14:36, QT escribió:
> Dear Sirs,
>
> When I use where statement, I see that there is no meaning small and big
> letter. Without looking small caps or big, result comes back. But I want to
> match only small letters. How can I do that?
>
> Best REgards