database - SQLite Autoincrement reset sorting By varchar column -

I have filled out a database, and I want to reset the numerical autoincrement ID, but I want to leave it in it I find a special sort of sorting by the varchar (text) value column, by retrieving items in the table.

I know there are many such questions, but I have not found anybody who likes it.

You should be able to join one with something like this Select statement:

  select INSERT (col_a, col_b) in new_ table, col_a, col_b from old_table ORDER BY col_b