MySQL查询以迭代方式为字段赋值

I am using a MySql table with 500,000 records. The table contains a field (abbrevName) which stores a two-character representation of the first two letters on another field, name. I am using a MySql table with 500,000 records.