Re: recursive queries

I am looking to do a query on a self join table that returns the parent records. Obviously there are ways to do this, but just wondered if there are any functions in MySQL that make this easier, or specific functions available to stored procedures. I have read the manual and couldn't find any

recursive queries

Title: DIY MTB Is there any built in or other support for recursive queries . I suspect not, but wonder what is considered the best approach. With stored procedures being supported in 5.0 is that the way to handle these. Thanks -- Duncan Miller [EMAIL PROTECTED] www.diymtb.com.au

Re: Evaluating text as an expression

n the later releases. Sorry for any confusion I caused! Rhino - Original Message - *From:* Duncan Miller <mailto:[EMAIL PROTECTED]> *To:* Rhino <mailto:[EMAIL PROTECTED]> *Cc:* mysql@lists.mysql.com <mailto:mysql@lists.mysql.com> *Sent:* Monday, Novemb

Re: Evaluating text as an expression

ino wrote: See comments interspersed below. Rhino - Original Message - From: "Duncan Miller" <[EMAIL PROTECTED]> To: Sent: Sunday, November 06, 2005 8:36 PM Subject: Evaluating text as an expression I am trying to set up a table where the returned value is a res

Evaluating text as an expression

I am trying to set up a table where the returned value is a result of evaluating an expression that is stored as text (or varchar). The idea is to have a table with a couple of fields that can contain numeric values or expressions eg NameFred Years 3 Commission base 10% Commissi