MySQL Hierarchy based on email

Asked Jan 16 '19 at 18:33

Active Jan 30 '19 at 16:32

Viewed 23 times

I have an Employees database with MySQL v5.6 as following:

| emp_name | emp_email | direct_manager_email |
|    x     |  x@co.com |      y@co.com        |
|    z     |  z@co.com |      x@co.com        |
|    y     |  y@co.com |      m@co.com        |

For example: I want to run a query to get all childs of y@co.com, so I get:

| emp_name | emp_email | direct_manager_email |
|    x     |  x@co.com |      y@co.com        |
|    z     |  z@co.com |      x@co.com        |

How can I get that?

This question is not a duplicate, the other one is depending on integer values not strings.

edited Jan 30 '19 at 16:32

asked Jan 16 '19 at 18:33

CairoCoder

3,091
11
46
68

Which MySQL version? – Raymond Nijland Jan 16 '19 at 18:34
@RaymondNijland, v5.6 – CairoCoder Jan 16 '19 at 18:35
All possible MySQL 5.6 recursive methods are in that duplication link. – Raymond Nijland Jan 16 '19 at 18:37
@RaymondNijland, they’re all based on levels, not emails. I already reviewed them before posting my question. – CairoCoder Jan 16 '19 at 18:46
@RaymondNijland, This question is not a duplicate, the other one is depending on integer values not strings. – CairoCoder Jan 30 '19 at 16:33
Then you should have mentioned that in the question..If you had reviewex or tryed those methods – Raymond Nijland Jan 30 '19 at 17:49
@RaymondNijland, I just did. – CairoCoder Jan 30 '19 at 18:19
@RaymondNijland, still duplicate?! – CairoCoder Feb 07 '19 at 16:46
Well i don't have reopen rights.. "still duplicate?" Yes there are methods in that duplication link which can and will work with strings.. The function or (recursive) stored procedure is the best option. – Raymond Nijland Feb 07 '19 at 16:56

MySQL Hierarchy based on email

0 Answers0