check how many tables in your MySQL database have a column named product_type

-- check how many tables in your MySQL database have a column named product_type
SELECT table_name
FROM information_schema.columns
WHERE column_name = 'product_type'
AND table_schema = 'database_name';