mysql - How to find records of a column if the data type of a column has been changed using a where condition -

to know data types of columns in table are, use 'desc schema.table_name'. if particular column's data type has been changed character numeric.

how check if there records in table data type character.

i see select distinct column_1 schema.table_name gives distinct values in column

but can check if data type of 'character' got table using where condition?

if using sql. can use query.

select column_name table_name column_name not [0-9]