update last record

a b text
1 1 t1
1 2 t2
1 3 t3
2 4 t4
...



update table set text = 'sometext'
where a = 1 and b = (select max(b) from table where a = 1)


this does not work -->

You can't specify target table 'table' for update in FROM clause

found something that works:


update table set text= 'sometext'
where a= '1'
order by b desc limit 1