From e9b709c12a9f64ab99b361a93c173548382147fd Mon Sep 17 00:00:00 2001 From: René 'Necoro' Neumann Date: Tue, 13 Feb 2024 20:45:09 +0100 Subject: Check username in lowercase --- sql/users.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/users.sql b/sql/users.sql index 3e0e992..9f1b5ef 100644 --- a/sql/users.sql +++ b/sql/users.sql @@ -5,7 +5,7 @@ SELECT * -- name: GetUserByName :one SELECT * FROM users - WHERE name = ?; + WHERE LOWER(name) = LOWER(?); -- name: GetUserById :one SELECT * -- cgit v1.2.3-70-g09d2