I need to separate where to validates values with conditional, Example
email := "test@test.com"
if email != "" {
db.Where("users.email LIKE ?", "%"+email+"%")
}
db.Where("users.name like ?", "%"+jhon+"%").Find(&users)
That returns two queries:
1: SELECT "users".* FROM "users" WHERE users.email LIKE '%test@test.com%'
2: SELECT "users".* FROM "users" WHERE users.name LIKE '%jhon%'
but I need the result in only one query:
SELECT "users".* FROM "users" WHERE users.email LIKE '%test@test.com%' and users.name LIKE '%jhon%'
Thanks!