Are linked list with MySQL possible (advanced user only) ?

[xhtml]

For experts only :

Does any expert know how to make a MySQL request with only one (select and subselect) without using any loop with PHP ?
Sample data :

index    field       next
======|======|=====
1           car        3
2           boat       4
3           house    2
4           rocket    0

[mikesmith76]

may be able to answer with more information, for a start what are you trying to achieve?

[sacx13]

Originally Posted by xhtml

For experts only :

Does any expert know how to make a MySQL request with only one (select and subselect) without using any loop with PHP ?
Sample data :

index    field       next
======|======|=====
1           car        3
2           boat       4
3           house    2
4           rocket    0

Something like that :

select * from table as t1 left join table as t2 on t2.field=t1.index;

???????????
This is what you want ?