Produce a MySQL info message similair to "/* 0 rows affected, 246 rows found. Duration for 1 query: 0.109 sec. */"

Question

G'Day,

In a MySQL trigger is it possible to generate an information message so that it will flow down the connection (Using AnyDAC & Delphi) so that it can be displayed on the client?

There does not appear to be a PRINT statement like MSSQL available in MySQL. I realise you can do SELECT "MyMessage" as a way to do debugging, but I want the information to come down the connection just like informational and error messages do.

Any pointers, suggestions appreciated.

--Donovan