#
June 10, 2013 at 1:32 pm
not sure if this would belong here but giving it a shot.
This is likely a pretty easy query but I’m new to this so apologies as I learn and navigate my way around.
I was a table that have some entries that need updating.
I’ve done some research left and right and this is what I found as the solution:
UPDATE tablename SET tablefield = replace(tablefield,”findstring”,”replacestring”);
the issue i’ve been having is:
the 1st time I ran this, I needed to replace a value of “_2_” with “_some_word_”. When I ran this command, it replaced all appearances of “**2**” w/ “**0**”. so not only are my 2s now 0s but my **10s** are now **12s**.
what have I done wrong?? single quotes? doubles? no idea what to do other than manually change the cell values (drag).
as well, i can’t seem to find some proper docs on this. anyone have a resource? The main one doesn’t seem to discuss this. A few times I was told that i was using commands that were not part if my current version.
Thanks for you time.
cheers.