I was trying to update approx 20,000 records in a table by using statements like this one,
however, I got the message say
0 row(s) affected
UPDATE nc_files SET title ="Worklog details" WHERE "log_name" LIKE "%PC01%"
PC01.TXT | Worklog details
PC02.txt | Project Summary
PC03.DOC| Worklog details
PC04.doc| Project Summary
PC01 | Worklog details
PC02 | Project Summary
log_name is a field name, remove literal quotes from it -
UPDATE nc_files SET title ="Worklog details" WHERE log_name LIKE "%PC01%"