SQL UPDATE with LIKE

The log_name is a field name, remove literal quotes from it -

UPDATE nc_files SET title ="Worklog details" WHERE log_name LIKE "%PC01%"

this is because your column name log_name should not be in ' quotes.

"log_name" LIKE "%PC01%" condition will always fail and zero rows will get updated, try this:

UPDATE nc_files 
SET title ="Worklog details" 
WHERE log_name LIKE "%PC01%";