Search:

Update: after playing around a lot I've hacked together a query that works, but isn't as efficient as I know it could be.


SELECT nested_category.name, nested_category.category_id,...

So I'm using MySQL and storing my category structure based on the Nested Set / Modified Pre-Order Tree Traversal model, in a table named "nested_category" which has fields: category_id, name, lft,...