diff options
| author | Unknwon <u@gogs.io> | 2016-03-16 16:55:19 -0400 |
|---|---|---|
| committer | Unknwon <u@gogs.io> | 2016-03-16 16:55:19 -0400 |
| commit | ff731ea07dd695fc49dc2e1e158e47867a613379 (patch) | |
| tree | fb38c2710e85da28a7ea37e973e4ba0dda9c5633 /models/user.go | |
| parent | 9a5a27ea8d855e8724ebb066a40e43a7dea119f5 (diff) | |
| download | gitea-ff731ea07dd695fc49dc2e1e158e47867a613379.tar.gz gitea-ff731ea07dd695fc49dc2e1e158e47867a613379.zip | |
#2814 LOWER() column value within search
Diffstat (limited to 'models/user.go')
| -rw-r--r-- | models/user.go | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/models/user.go b/models/user.go index a1d1f3b211..e6717aecdf 100644 --- a/models/user.go +++ b/models/user.go @@ -1140,8 +1140,8 @@ func SearchUserByName(opts *SearchUserOptions) (users []*User, _ int64, _ error) searchQuery := "%" + opts.Keyword + "%" users = make([]*User, 0, opts.PageSize) // Append conditions - sess := x.Where("lower_name like ?", searchQuery). - Or("full_name like ?", searchQuery). + sess := x.Where("LOWER(lower_name) LIKE ?", searchQuery). + Or("LOWER(full_name) LIKE ?", searchQuery). And("type = ?", opts.Type) var countSess xorm.Session |