Rails-Where Like查询不返回所有大写字母[重复]的结果

我猜你在用Postgres。

ILIKE

Job.where('title ILIKE ? OR duration ILIKE ?', "%#{params[:search]}%", "%#{params[:search]}%")

或者是一个狡猾的黑客 lower() :

Job.where('lower(title) LIKE lower(?) OR lower(duration) LIKE lower(?)', "%#{params[:search]}%", "%#{params[:search]}%")

def query_job(query)
  job_query = "%#{query.downcase}%"
  Job.where("lower(title) LIKE ? or lower(duration) LIKE ?", job_query, job_query) 
end 

query_job(params[:search])