2019-06-12 07:01:04 103.226.196.* 对p**h说:
SELECT ft.* , LENGTH(path)-LENGTH(REPLACE(path,'/','')) as len from ft where path like '/%'
having len = 3
;

SELECT ft.* from ft where '/1/3/4' like concat(path,'/%');
回复

关于本站 @ 2018