Scot Ranney • November 10, 2024
1. Using SQL Operations in PHPMyAdmin requires "back ticks" `
for column names but double quotes "
for values.
Example:
update `s08_openreviews_REVIEWS` set `type_code` = replace(`type_code`, "50pmc2s-review", "p4");
You will know there is something wrong if an "unknown column" error comes up.