[MYSQL] A recursive query?

[eluser]m_ologin[/eluser]
I would probably add a 'children' column in your sql structure (varchar) that would hold the IDs of the children for that item:

Code:

ID| title | children
1 | "aze" | "2,4"
2 | "sdg" | "4"
3 | "erh" | "5,6"
4 | "zdh" | ""
5 | "shf" | ""
6 | "tyi" | ""

Then with only one query, find the recursive children of 1 :

Code:

SELECT * FROM t_... WHERE ID IN (SELECT children FROM t_... WHERE title="aze")