PostgreSQL 數據庫

函數upper（“字符串”）：轉成大寫字符串

WHERE UPPER("User_Name") LIKE upper(username) 此句查詢“User_Name” 中值大小寫不區分。

SELECT “User_Id”,”User_Image”,”User_Name”,”User_Birthday”,”User_Sex”,”User_OnlineLat”,”User_OnlineLon”,”User_State”,
(SELECT COUNT(*) FROM “tbUsers” WHERE UPPER(“User_Name”) LIKE upper(username)) AS “user_count”
FROM “tbUsers”
WHERE UPPER(“User_Name”) LIKE upper(username) LIMIT 10 OFFSET 0;