I am assuming that you have one field named ID in your table, based on it your query to updated 10 latest record should be done following way,

UPDATE TABLENAME  SET COLUMMANGE = 'VALUE' WHERE ID in ( SELECT ID from TABLENAME ORDER BY COLUMNNAME DESC LIMIT 10 );

Here inner query will select 10 latest record id from the table. These Ids will be passed to outer Update query.

I believe you need an nested query first to fetch the primary keys (or some other key) of the rows you want to update, and than update only those rows. Try something like this:

 UPDATE TABLENAME SET COLUMMANGE='VALUE' WHERE id IN (     SELECT id FROM (         SELECT id FROM TABLENAME         WHERE <YOUR CONDITION>         ORDER BY COLUMNNAME ASC         LIMIT 10     ) );

It is also been discussed here if you want more details:update multiple rows using limit in mysql?.

But really think if you really want this behaviour. Also the WHERE 1 is not a part of the valid SQL syntax .

Try this query

UPDATE TABLE_NAME  SET COLUMN_NAME = 'VALUE' WHERE PRIMARYKEY_COLUMN in ( SELECT PRIMARYKEY_COLUMN  from TABLE_NAME ORDER BY COLUMNNAME DESC LIMIT 10 );

• PRIMARY KEY COLUMN IS MANDATORY IN THIS TABLE.

• THE ABOVE QUERY RESULTS TOP 10 RECORDS IN DESCENDING ORDER

• android
• sqlite