Convert BIGINT UNSIGNED to INT
===

I know it is unorthodox and potentially dangerous to want to convert a something from a larger size to a smaller size data type. However, in this case, it is extremely unlikely that the value of the `BIGINT UNSIGNED` column is ever larger than the maximum size of an `INT` column.

So, using MySQL, I'm reading the table structure. While reading the `information_schema.columns.ordinal_position` column, I realized that it is of type `BIGINT UNSIGNED`. Now, I want this as an `INT` instead for my processing purposes. I want to cast/convert the type in SQL.

`CAST` and `CONVERT` only allow me to change the sign of the data type, apparently.

    SELECT CAST(ordinal_position AS SIGNED)
    FROM information_schema.columns

I want the column specifically returned as an `INT`. E.g. chop the column at the maximum value of an `INT` and return that value.

For now I will just change the datatype after I pull the value back. But I'd like to know how to do it in SQL.