Hey try this, though there are probably better ways,
"SELECT * FROM foo WHERE name REGEXP '^[PHP]'";
James
""Bass¨Ð¦õªv"" <[EMAIL PROTECTED]> wrote in message
9egfot$cfu$[EMAIL PROTECTED]">news:9egfot$cfu$[EMAIL PROTECTED]...
> Hi ,
> By defualt , select rows from Mysql is case insenstive .
> For exmaple ,
> select * from foo where name = 'PHP'
> select * from foo where name = 'php'
> is the same
>
> how can i do a queny which
> select * from foo where name = 'PHP'
> is success
> but
> select * from foo where name = 'php'
> fail ??
>
> given that name = 'PHP' in the database
>
> thx
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
