|
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?
Navigation:
[Reply to this message]
|