How can I replace the ampersand in my database?

Question

How can I replace the ampersand in my database?

I have about 6 thousand rows of data where we have &

in different different rows. I would like to replace this with an ampersand if possible. Can someone please tell me how to do this using mysql? Thanks to

+2

mysql

jim 23 Sep At 11:32 pm

source to share

1 answer

gahooa · Accepted Answer · 2009-09-23T23:37:50+0000

The MySQL REPLACE function should work nicely:

UPDATE tablename SET fieldname = REPLACE(fieldname, "&amp;", "&");

How can I replace the ampersand in my database?

More articles: