find_in_set( 205, ancestors )

find_in_set(205, ancestors)是一种MySQL函数，它用于判断给定的值205是否在字段ancestors中。该函数会将字段ancestors中的值以逗号分隔，并在其中查找给定值205。如果找到了该值，则返回非零值；否则返回0。所提到的示例中，使用了该函数来判断字段ancestors中是否包含值为205的子节点。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [ORACLE实现MySQL中find_in_set同名函数功能,oracle使用find_in_set函数,oracle集成mybatis使用find_in_set...](https://blog.csdn.net/ayunnuo/article/details/119210425)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* [sql中的find_in_set函数](https://blog.csdn.net/coding_L/article/details/125738498)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]