[mythtv] Joining on a calculated column

[David Engel]

On Mon, Jan 10, 2005 at 10:13:29PM -0500, Jeremiah Morris wrote:
> On 10 Jan 2005, at 9:52 PM, David Engel wrote:
> >Does that
> >mean I'll have to replicate the calculation in all three places?
> 
> AFAIK, yes. User functions are only in the MySQL 5.x development. With 
> MySQL 4.1, you could use a sub-select to create a virtual table with 
> the calculation done once. With 3.x and 4.0, I think you're stuck doing 
> it the long way.

That's what I've done for now.  Man, is it ugly!  Thanks again.

David
-- 
David Engel
gigem at comcast.net