In the last episode (Jan 25), Graham said:
> I have looked at the documentation and have been unable to locate any
> information in respect of calculated fields. Can anyone verify the
> lack of this feature in mysql or point me to the area of the
> documentation which discusses them if the are indeed included. If
> they are not available has anyone suggestions for how I may work
> around this lack of functionality.
MySQL does not support views (which is what I assume you're talking
Either add another physical field, and do the calculation as you insert
the rest of the data, or calculate the field on the fly as you select.