mysql将字段逗号分隔为list

最新推荐文章于 2024-07-22 03:11:15 发布

武六七

最新推荐文章于 2024-07-22 03:11:15 发布

阅读量3.4k

点赞数 1

分类专栏： SQL 文章标签： mysql

本文链接：https://blog.csdn.net/w567wzf/article/details/103562710

版权

SQL 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

mysql将字段逗号分隔为list

select distinct 
substring_index(substring_index(a.nurse_dept, ',', b.help_topic_id+1), ',', -1)   
from his_nurse as a  
join mysql.help_topic b on 
b.help_topic_id < (length(a.nurse_dept) - length(replace(a.nurse_dept,',',''))+1)

SELECT * FROM his_doctor
where  1 = 1
and concat
(ifnull(pinyin_code,''),ifnull(doctor_name,''),ifnull(wubi_code,'')) 
like concat('%',#{keyWords},'%')
and FIND_IN_SET(#{deptId}, doctor_dept)