MySQL Trigger That Sends Email

Hi, We need a MySQL trigger written. Here is what it needs to do: 1. The trigger fires upon insertion to a table. 2. The trigger reads data from the inserted record (order). It has to do a join to get data from a referenced table (product) as well. 3. The trigger reads configuration data from another table. (email address to send to, email text) 4. The trigger emails the data in the record to the email address specified in the configuration record. This is a MySQL db running on Linux. The database supports a low-valume Joomla website.