MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

5.7.32

SELECT DATABASE()

DATABASE()

db_340890889

CREATE TABLE table1 (ID int PRIMARY KEY NOT NULL, endDate datetime);
INSERT INTO table1 (ID, endDate)
VALUES (1, '2020-02-02');

CREATE TABLE table2 (ID int PRIMARY KEY NOT NULL, end_date datetime);
INSERT INTO table2 (ID, end_date)
VALUES (1, '2020-03-02');

CREATE TABLE table3 (ID int PRIMARY KEY NOT NULL, EndDate datetime);
INSERT INTO table3 (ID, EndDate)
VALUES (1, '2019-02-02');

SELECT * FROM table1;
SELECT * FROM table2;
SELECT * FROM table3;

SELECT DISTINCT TABLE_NAME, COLUMN_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME LIKE 'End%';

ID
endDate

1
2020-02-02 00:00:00

ID
end_date

1
2020-03-02 00:00:00

ID
EndDate

1
2019-02-02 00:00:00

TABLE_NAME
COLUMN_NAME

EVENTS
ENDS

table1
endDate

table2
end_date

table3
EndDate

events_stages_current
END_EVENT_ID

events_stages_history
END_EVENT_ID

events_stages_history_long
END_EVENT_ID

events_statements_current
END_EVENT_ID

events_statements_history
END_EVENT_ID

events_statements_history_long
END_EVENT_ID

events_transactions_current
END_EVENT_ID

events_transactions_history
END_EVENT_ID

events_transactions_history_long
END_EVENT_ID

events_waits_current
END_EVENT_ID

events_waits_history
END_EVENT_ID

events_waits_history_long
END_EVENT_ID

TABLE_NAME	COLUMN_NAME
EVENTS	ENDS
table1	endDate
table2	end_date
table3	EndDate
events_stages_current	END_EVENT_ID
events_stages_history	END_EVENT_ID
events_stages_history_long	END_EVENT_ID
events_statements_current	END_EVENT_ID
events_statements_history	END_EVENT_ID
events_statements_history_long	END_EVENT_ID
events_transactions_current	END_EVENT_ID
events_transactions_history	END_EVENT_ID
events_transactions_history_long	END_EVENT_ID
events_waits_current	END_EVENT_ID
events_waits_history	END_EVENT_ID
events_waits_history_long	END_EVENT_ID