How to write a database that updates the data with the smallest integer field

How can I write a database that updates the data with the smallest integer field? Update & nbsp; tabname & nbsp; set & nbsp; field1 = 'value1' & nbsp; where & nbsp; count & nbsp; in & nbsp; (select & nbsp; min (count) & nbsp; from & nbsp; tabname) & how to write a data record that updates the smallest integer field in the nb Database?
Update tabname set field1 = 'value1' where count in (select min (count) from tabname) limit 1;

You can't specify target table 'tabname' for update in FROM clause ....
------ Solution --------------------
Update tabname set name = 'value1' where count in (select * from (select min (count) from tabname) as t) limit 1;

Or

Update tabname set field1 = 'value1' order by count asc limit 1