I want to automate moving values from one row to other by using function like RIGHT, the thing is i need to take from one col (row) 2 last letters and put them into the other column but in the same id/row. ScreenShots should clear some things up.

CodePudding user response：

You can run an update query.

Make a join with the same table and update the new field with your RIGHT() function:

UPDATE tableName INNER JOIN tableName as tableName1 ON tableName.ID = tableName1.ID SET tableName.KodNrProjektu = RIGHT(tableName.NumerProjektu, 2)

Before:

After: