mybatis实现传一个参数多字段搜索

通过name查询出包含name的医院名称、科室名称、医生名称的信息

<select id="queryListByOrgDoctor" parameterType="Map"
		resultType="com.aa.database.entity.OrgDoctor">
		SELECT 
		o.*,
		a.account as "doctorAccount.account",
		k.id as "hospitalKeshi.id",
		k.name as "hospitalKeshi.name"
		FROM org_doctor as o 
		LEFT JOIN hospital as h on h.id = o.hospital_id
		LEFT JOIN hospital_keshi as k on k.id = o.keshi_id
		LEFT JOIN platform_account as a on o.doctor_account_id = a.id
		<where>
			doctor_role = "doctor" 
			<if test="name != null and name != ''">
			and CONCAT(o.username,k.name,h.name) LIKE CONCAT('%',#{name},'%') 
			</if>
			
		</where> 
		order by o.create_time desc
	</select>