WARNING:
THIS CODE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED; THE AUTHOR DISCLAIMS ALL LIABILITY FOR ANY DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR STORE DISRUPTIONS ARISING FROM ITS USE.
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.
phpmyadmin