Peter Lauri wrote:
Yes, and this shows that you can not do it will MySQL purely :) But a scripting language like php can do it for you with a recursive function as the best option.
IMHO, the best option would do it with a procedure as you don't get out of the database and don't have any overhead from outside.
--renato -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]