From ff731ea07dd695fc49dc2e1e158e47867a613379 Mon Sep 17 00:00:00 2001 From: Unknwon Date: Wed, 16 Mar 2016 16:55:19 -0400 Subject: #2814 LOWER() column value within search --- models/repo.go | 2 +- models/user.go | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) (limited to 'models') diff --git a/models/repo.go b/models/repo.go index abe67a6d..2f8019fe 100644 --- a/models/repo.go +++ b/models/repo.go @@ -1520,7 +1520,7 @@ func SearchRepositoryByName(opts *SearchRepoOptions) (repos []*Repository, _ int repos = make([]*Repository, 0, opts.PageSize) // Append conditions - sess := x.Where("lower_name like ?", "%"+opts.Keyword+"%") + sess := x.Where("LOWER(lower_name) LIKE ?", "%"+opts.Keyword+"%") if opts.OwnerID > 0 { sess.And("owner_id = ?", opts.OwnerID) } diff --git a/models/user.go b/models/user.go index a1d1f3b2..e6717aec 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 -- cgit v1.2.3