mysql搜索多表多字段模糊查询

select parttime_job_business_assessments.*, u.nick_name, u.mobile, pj.name as job_name, b.name as business_name from `parttime_job_business_assessments` left join `users` as `u` on `u`.`id` = `parttime_job_business_assessments`.`user_id` left join `parttime_jobs` as `pj` on `pj`.`id` = `parttime_job_business_assessments`.`job_id` left join `businesses` as `b` on `b`.`id` = `parttime_job_business_assessments`.`business_id` where 1 = 1 AND concat(pj.`name`, u.`nick_name`,u.`mobile`,b.`name`) LIKE "%郝%" order by `parttime_job_business_assessments`.`sort_id` desc limit 10 offset 0 select parttime_job_business_assessments.*, u.nic