mysql语句 (递归查询)
SELECT MAX(s. LEVEL)-1 AS `level` FROM ( SELECT @l := @l + 1 AS LEVEL, @id := ( SELECT parent_id FROM cate WHERE id =@id ) FROM cate a, (SELECT @id := 3, @l := 0) b WHERE @id IS NOT NULL ) s
大致表(cate)如下:
id | parent_id | name |
1 | 0 | aaa |
2 | 1 | bbb |
3 | 2 | ccc |
mysql代码块中@id := 3的数字改为你想要的那条信息的id,即可得出所在等级。