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
jim
source
to share
1 answer
The MySQL REPLACE function should work nicely:
UPDATE tablename SET fieldname = REPLACE(fieldname, "&", "&");
+7
gahooa
source
to share