On 23-May-01 Bass¨Ð¦õªv wrote:
> 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
>
where BINARY name = 'php'
(BINARY casts were added in 3.23.?)
you also might consider changing your column to varchar() binary.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
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]
