Re: CLIKE in MySQL-Query
| From: | andreas \(@work\) | Date: | Mon, 28 Aug 2000 14:17:08 +0000 |
| Subject: | Re: CLIKE in MySQL-Query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-13942@lists.php.net to get a copy of this message | ||
hi,
use BINARY if you run mySQL >= 3.23.0
samples:
msql> select "a" = "A";
-> 1
msql> select BINARY "a" = "A";
-> 0
where 1 .... true 0 .... false
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
_/_/ viva technologies
_/ gstrein andreas
> for example a valid combination of 'frage' and 'antwort' would be:
>
> frage: hello there
> antwort: my name is jochen
>
> the following combination should not be allowd:
>
>
> frage: Hello There
> antwort: my name is jochen
>
> but the follwing line accepts bothe combinations?
>
> what's wrong????
>
> $query = mysql_query("SELECT pass FROM users WHERE frage CLIKE
> '$recover_frage' AND antwort CLIKE '$recover_antwort'");
>
>
> jochen kächelin
>
> mailto:info@bemorph.de
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>