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

0
PostgreSQL 2073 次浏览

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

请尽量让自己的答案能够对别人有帮助

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