Query to check if trigger exist on a MYSQL table

Question

Is there a query which lists all the triggers created for any event on a particular table. Say I have a table named `client`, and I want to list all the triggers creared for any event(say insert/update/delete etc) on that table. Any kind of help is appreciated

Accepted Answer

SHOW TRIGGERS

```
SHOW TRIGGERS LIKE '<tablename>'
```

e.g.

```
SHOW TRIGGERS LIKE 'client'
```

Query to check if trigger exist on a MYSQL table

Solution

Problem