Thread
:
[Help] Query to replace just one character...
View Single Post
#
3
08-02-2017, 12:03 PM
Fridgecritter
Hill Giant
Join Date: Feb 2008
Posts: 195
SOLVED
I was using ' ' instead of quotation marks to designate the character to replace (" "). Here is the query I ran on the database to replace all of the apostrophes with acute accents:
Code:
UPDATE items SET name = REPLACE(name,"'","`");
Fridgecritter
View Public Profile
Send a private message to Fridgecritter
Find all posts by Fridgecritter