UPDATE cms3_objects
SET type_id= o2.type_id
FROM cms3_objects as o2
WHERE name LIKE "«UNIPAK» (Фум лента «Jumbotape»)"
AND owner_id=21518
AND o2.name LIKE "«UNIPAK» (Фум лента «Jumbotape»)"
AND o2.owner_id!=21518;
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM`cms3_objects`as`o2` FROM cms3_objects WHERE name LIKE "«UNIPAK» ' at line 2