sql - Converting varchar to int using phpmyadmin -

I try to convert a table from varchar to int I am staying The reason for this is that I am trying to order numbers on my website by the highest order. This is not a problem, but because it's a variable that orders them wrong.

When I try to convert to INT table in PhpMyAdmin, I get this error:

1283 - The column 'Referral' integer Can not be part of index

Maybe I have to ask a question. All help is quite commendable.

You have a full text index associated with your referral Type must be deleted successfully before changing:

Alternate table of your_table drop index (full-test_indix_name);

Before leaving the index, check whether it refers to other columns in the table, because you have to work for the index (except the referral column)) For full text search.