- 背景
我想实现输入/ 显示
/aaaa/bbb
/aaaa
/
2. 实现
select * from fm_file_details_info
where (LENGTH(f_node) -LENGTH(REPLACE(f_node, '/', ''))) = (LENGTH('/') -LENGTH(REPLACE('/', '/', '')))
我想实现输入/ 显示
/aaaa/bbb
/aaaa
/
2. 实现
select * from fm_file_details_info
where (LENGTH(f_node) -LENGTH(REPLACE(f_node, '/', ''))) = (LENGTH('/') -LENGTH(REPLACE('/', '/', '')))