ALTER TABLE `users_table` ADD INDEX `ip_index` (`ip_column`)
Source: https://stackoverflow.com/questions/14419090/adding-index-to-column-in-mysql