時間:2024-03-07 21:27作者:下載吧人氣:17
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;
網友評論