Mysql: Get all the linked rows in a table

Question

I have a table structure

kinda like this

id  |   title | next 
1   |  test   | 5
2   |  test   | 0
3   |  test   | 0
4   |  test   | 0
5   |  test   | 3

Now, as you see 1 points to next item 5 and 5 points to next item 3 and 3 denotes the end

I need a query, from which I can get 1, 5, 3 serially in one column and their title also

like

result | title
--------------
1      |  test
5      |  test
3      |  test
--------

please help. I dont even know how to get started at such query.

Answer 1

What you need is a tree query - check Is it possible to query a tree structure table in MySQL in a single query, to any depth?