diff options
Diffstat (limited to 'models')
| -rw-r--r-- | models/repo.go | 2 | ||||
| -rw-r--r-- | models/user.go | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/models/repo.go b/models/repo.go index abe67a6d8e..2f8019feed 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 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 |