How to search for a column name?

Hello,

I need to add to a table a column "year". I wonder if such columns are already present in the database and what it ther type and other settings.

I would like to search my database for all columns containing "Year" is that possible?

On MariaDB and MySQL, and on some others, you have the information_schema.columns table, which you can browse with HeidiSQL's data tab.