Thank you, I ended up using phpmyadmin to backup the table, edit it in ultraedit then truncate and re-install.
This particular site shows MySQL:
Client API version 3.23.58
The web host claims the server install is 4.something, but maybe the difference is the issue? I always see errors here not seen on other sites when I update it - just when I think it's safe to upgrade the bottom falls out and something simple isn't.