mysql triggers

[art346]

Newb question

I searched for the solution, but couldn't find any. Is it possible to apply a trigger to a table filed, for example if I have a filed with a value something like 'alex', can I create a trigger to concatenate the '@aol.com' to make it '[email protected]', when the field is requested from application?

Thanks in advance!

 

[jnjc]

I don't really use MySQL triggers but doing a quick search I can't find much info on read triggers. You might be best looking at Create/Update triggers to modify the data as it's written.

HTH,
JC

 

[Erik]

Perhaps try using a container class. The container class contains a property (variable) for each field in the table. There is a get and set method for each property. The get method for the email address is where I would append the "@aol.com" value.

-Erik

 

[art346]

Thanks!

Thanks for ideas! I'll try it.