> I have a column where I need to replace all instances of the text "US-
> Complete" (contained within a long sentence) with "US Complete".
> There are probably 50 or 100 of them. I'm really scared to do it
> since I can't risk screwing up that column - what's the correct syntax?
When you screw up, that's when you do a "rollback". Welcome to
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!