nsssim · August 29, 2015 14:14
diff --git a/find_field_in_db b/find_field_in_db
 SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('xxxxx','yyyyyy')
        AND TABLE_SCHEMA='database_name';

 //will find xxxxx and yyyyyy in the databae
	SELECT DISTINCT TABLE_NAME
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE COLUMN_NAME IN ('xxxxx','yyyyyy')
	AND TABLE_SCHEMA='database_name';

	//will find xxxxx and yyyyyy in the databae