sql 函数 find_in_set, concat

select count(*) from sys_dept where find_in_set("T0001", ancestors) or dept_id="T0001"

select count(*) from sys_dept where ancestors like concat('%', 'T0001', '%') or dept_id='T0001'

 

posted @ 2021-07-28 10:47  northli  阅读(88)  评论(0)    收藏  举报