title: Mysql: Find all stored procedures that reference a specific table
body: <p>I want to check all SPs/function that reference a particular table in mysql. I found a query which I belive is to check the same in sql server:</p>
  
  <pre><code>SELECT Name
  FROM sys.procedures
  WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%tablename%'
  </code></pre>
  
  <p>But in mysql it says 'Table sys.procedures doesn't exist'</p>