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.
mvkb_phpmyadmin
