2021
01-10
01-10
PostgreSQL LIKE 大小写实例
PostgreSQL数据库函数upper(“字符串”):转成大写字符串WHEREUPPER("User_Name")LIKEupper(username)此句查询“User_Name”中值大小写不区分。SELECT"User_Id","User_Image","User_Name","User_Birthday","User_Sex","User_OnlineLat","User_OnlineLon","User_State",(SELECTCOUNT(*)FROM"tbUsers"WHEREUPPER("User_Name")LIKEupper(username))AS"user_count"FROM"tbUsers"WHEREUPPER("User_Name")LIKEupp...
继续阅读 >