MySQL selecting record based on parent

Question

I got a table with the user name and their guarantor. I want to select the record based on 1 name and follow by the guarantor and continue search next record based on this guarantor's guarantor.

=========================
Name        | ParentName
=========================
Ali         | Abu
Bola        | Ali
Cat         | Bola
Danny       | Cat
Dog         | Elephant
=========================

When I put in Danny to the parameter, my expected result will be :

=========
Name
=========
Danny
Cat
Bola
Ali
=========

Is there any possibility to done it with query?

you can do with procedure – Ramin Darvishov May 18 '16 at 10:36 — Ramin Darvishov, May 18 '16 at 10:36

score 0 · Answer 1 · edited May 23 '17 at 12:23

0

Yes, you can do it! You need to create a recursive query using functions/procedures.

Read here

edited May 23 '17 at 12:23

Community

1
1

answered May 18 '16 at 10:41

granmirupa

2,780
16
27

MySQL selecting record based on parent

1 Answers1