Re: how to search in text ?(怎么避免在TEXT字段中大小写的混合查找？)

[Ramalingam Chelliah]

Hi,
By default pattern matching is case-insensitive ...

Use BINARY keyword to make it case sensitive...

mysql>select * from testabc where stext like BINARY '%b%';

This should do the trick...

Refer: http://dev.mysql.com/doc/mysql/en/Pattern_matching.html

Regards,
Ram.


We Learn the Most When we have to Invent