Search in NestedSets

[Florian Krebber]

hello everyone...

i hope i am right in this part of the forum with my problem. this is what driving me nuts since a long time:

i have 3 tables, one for adresses, one for a structure and one for referencing both together. the structure table is a nested sets table. everything is fine, reading, checking the tree, insert etc.

so now i want to search in the adresses for a specific one. let's say i make a search LIKE '%Schmit%' or whatever. i need help how i can get the adress, the structure element that it is in AND the whole tree above this element with ONE query. it's driving me nuts. i can't figure it out.

by the way the only information that i am storing in the reference table is the id of the adress and the id of the structure element that it is in. and sure each entry in this table has also a id.

thanks a lot for your help.