Redian新闻
>
how to do a case insensitive comparison
avatar
how to do a case insensitive comparison# Database - 数据库
l*e
1
when i do a
select * from table_name
where column = 'blah blah';
The comparison is case sensitive.
How can i do it case sensitive? Thanks a lot, Da Xias.
avatar
p*y
2
全部转换成小写或大写.

【在 l******e 的大作中提到】
: when i do a
: select * from table_name
: where column = 'blah blah';
: The comparison is case sensitive.
: How can i do it case sensitive? Thanks a lot, Da Xias.

avatar
q*j
3
how about "LIKE"?

【在 l******e 的大作中提到】
: when i do a
: select * from table_name
: where column = 'blah blah';
: The comparison is case sensitive.
: How can i do it case sensitive? Thanks a lot, Da Xias.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。