| 注册
请输入搜索内容

热门搜索

Java Linux MySQL PHP JavaScript Hibernate jQuery Nginx

Postgresql数据库查询数据,可以忽略大小写吗?

0
PostgreSQL 1800 次浏览

我记得mysql是忽略大小写,大小写无关的

2个答案

2
-1

The SQL standard way to perform case insensitive queries is to use the SQLupper or lower functions, like this: ... As you can see, the pattern is to make the field you're searching into uppercase or lowercase, and then make your search string also be uppercase or lowercase to match the SQL function you've used.

https://www.besanttechnologies.com/training-courses/data-science-training-in-bangalore