php - 如何基于 laravel 查询生成器编写此 mysql 查询

Question

我想转换以下支持 laravel 查询生成器的查询

select specialization_master.sm_specializationtype from 
specialization_master 
join hospital_profile_master on FIND_IN_SET(specialization_master.sm_id ,  (select hospital_profile_master.hp_specialization from hospital_profile_master where hp_hospitalid = 'HOS10011'))
group by specialization_master.sm_specializationtype

我是这样写的

$query_filter_dept_list = DB::table('specialization_master')
                            ->join('hospital_profile_master',DB::raw(FIND_IN_SET(specialization_master.sm_id , (select hospital_profile_master.hp_specialization from hospital_profile_master where hp_hospitalid = $hospital_id))))
                            ->select('specialization_master.sm_specializationtype')
                            ->groupBy('specialization_master.sm_specializationtype')
                            ->get();

但它显示错误ReceptionistController.php第35行中的FatalErrorException:语法错误，意外的“hospital_profile_master”(T_STRING)

Answer 1

是的，最后我使用了/DB::select();解决问题的方法及其工作正常。