Replace help?

Hi Guys,

I've googled this but can't find the right answer. Say I want to replace all instances of the character & in my database for 1,000's of records.

I thought it would be something like so:

Code:

---

update table set headline = replace('&','&');

---

Can anyone help?

Haven't actually tried this - but be careful: what about if you already have some cases of '&amp' in your database and you replace the '&' then they will end up as '&&amp'. :injured:

Quote:

---

Originally Posted by chris_stfc

I thought it would be something like so:

Code:

---

update table set headline = replace('&','&');

---

---

pretty close, but your REPLACE function was missing a parameter

UPDATE table SET headline = REPLACE(headline,'&','&');

:cool:

Thanks. Say I wanted to replace the ' character with Thanks. Say I wanted to replace the ' character:
with & # 39;

Does not seem to like it?:

Code:

---

UPDATE table SET headline = REPLACE(headline,''',''');

---

Does not seem to like it?

Code:

---

UPDATE table SET headline = REPLACE(headline,'''',''')

---