MySQL SHOW CREATE TRIGGER trigger name- Only return one column

Question

In MySQL when I run the syntax SHOW CREATE TRIGGER trigger_name the result is a table with the columns Trigger, sql_mode, SQL Original Statement, etc.

I only want the result to be SQL Original Statement. Is there a way to just return this one column?

Answer 1

Try using the INFORMATION_SCHEMA table instead:

SELECT  CONCAT('CREATE DEFINER =`',DEFINER,'` TRIGGER ', TRIGGER_NAME ,' ', ACTION_TIMING, ' ', EVENT_MANIPULATION, ' ON `', EVENT_OBJECT_TABLE, '` FOR EACH ', ACTION_ORIENTATION, ' ', ACTION_STATEMENT ) `trigger`
FROM    INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME = 'tgrAddSongPlay';