Posted by Bonge Boo! on 09/28/44 11:24

This is probably really obvious, but I can't find a quick answer.

I want to be able to do a "search and replace" style spelling correction on
a column because I have spelt a word incorrectly. However I don't know the
correct syntax for the SET command. If I use SET colname = %goodword% I
simply replace the entire column with %goodword%


UPDATE tbl_products SET product_name = "%goodword%" WHERE product_name LIKE
"%badword%"

Anyone help my poor brain out?

[Back to original message]