How to find where Mysql functions are used

Question

I'm using Mysql8. In one of the views I'm working on, there is a function called calculateGP. I want to modify this function but I'm not sure if this function is used elsewhere in the database. Is there a query that would let me know if this function is referenced elsewhere in the database?

P粉346326040 · Answer

By taking a MySQL structure dump of the database and doing a text search on the dump file, I was able to find a reference to the function calculateGP. This is an alternative way to find references in the database without running a MySQL query.

P粉378890106 · Answer

I will do this:

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
WHERE VIEW_DEFINITION LIKE '%`calculateGP`%'

If your table, column, or other identifier is also named calculateGP, this may find the wrong match.