Get all child and grand child nodes from a specific parent id

Asked Nov 13 '17 at 09:48

Active Jan 10 '20 at 14:18

Viewed 533 times

I need to get all child and grand child nodes from a specific parent id.

I got the query below from here, but it only ends at the 3rd level, i need it to go further.

i have been on this for about two weeks and in need of support.

 SELECT *
 FROM TABLENAME
 WHERE PARENT = 1
 UNION
 SELECT * 
 FROM TABLENAME
 WHERE PARENT IN 
(SELECT ID FROM TABLENAME WHERE PARENT = 1)

This is a sample of the mysql table

 id parent_id name
 1       NULL john
 2          1 Steve
 3          2 sandra

john has a parent id of steve, steve has the parent id of sandra, sandra is the grandchild of john.

i hope you understand what i mean here?...

edited Nov 13 '17 at 09:53

asked Nov 13 '17 at 09:48

Victor Mbachu

What DBMS do you use? – M. Prokhorov Nov 13 '17 at 10:13
i use mysqli to run it – Victor Mbachu Nov 14 '17 at 13:30
See [this question](https://stackoverflow.com/questions/20215744/how-to-create-a-mysql-hierarchical-recursive-query) – M. Prokhorov Nov 14 '17 at 14:39
Possible duplicate of [How to create a MySQL hierarchical recursive query](https://stackoverflow.com/questions/20215744/how-to-create-a-mysql-hierarchical-recursive-query) – M. Prokhorov Nov 14 '17 at 14:39

0 Answers0