Re: recursive search
From: Axel Schwenke <axel.schwenke_at_gmx.de>
Date: Mon, 12 Sep 2016 10:19:42 +0200
Message-ID: <nr5oer$hfm$1_at_dont-email.me>
Date: Mon, 12 Sep 2016 10:19:42 +0200
Message-ID: <nr5oer$hfm$1_at_dont-email.me>
[snip]
> Is there a way to achieve this just using sql ?
[Quoted] Yes. SQL has the CONNECT BY PRIOR clause to allow recursive queries. However it is not supported by MySQL (or any of it's forks)
If you google with this term, you will find several approaches how to deal with this using MySQL facilities. Including different modeling of hierarchic data (nested set model etc.) Received on Mon Sep 12 2016 - 10:19:42 CEST