【Mysql】一些简单查询

#查询层级菜单
SELECT
	m1.pid, m2.name AS pname,
	m1.id,  m1.name AS name
FROM meun m1
LEFT JOIN meun m2 ON m1.pid= m2.Id
where m2.name is not null
order by pname

#截取目录及文件名
SELECT
	SUBSTRING_INDEX( '/video/av/dddd.mp4', '/', 3 ) AS path,
	SUBSTRING_INDEX( '/video/av/dddd.mp4', '/', -1 ) AS filename

substring_index(str,delim,count)
   str:要处理的字符串
   delim:分隔符
   count:计数
count是正数，那么就是从左往右数，第N个分隔符的左边的全部内容;
相反，如果是负数，那么就是从右边开始数，第N个分隔符右边的所有内容。