How to remove double quote character in MySQL

Question

I've been used the solution, but it cannot solved for special character. I've tried

SELECT address FROM myDatabase.users
where substring(address,1,1) = '"';

What should I do to remove or change any special character or specific character in database like that??

anyway, after I ask my friend, he show me that the error come from setting in mysql workbench, I should to unselect "Safe Updates" check box in Edit >> Preferences >> SQL Editor >> Query Editor. thanks for the answer.

You know that query returns `address` where the first character is a `"` and doesn't do any replacement, right? (just making sure you know this) — Bernhard Barker, Sep 23 '13 at 07:55
I used it to show first, but it won't show, then replace with it just won't work too.. — Ahmad Azwar Anas, Sep 23 '13 at 08:01
Do you want to remove `"`'s everywhere in the string, regardless of what it starts with? If so, your query is a bit misleading. — Bernhard Barker, Sep 23 '13 at 08:04
possible duplicate of [MySQL - Replace Character in Columns](http://stackoverflow.com/questions/7734077/mysql-replace-character-in-columns) — Bernhard Barker, Sep 23 '13 at 08:07

score 4 · Accepted Answer · answered Sep 23 '13 at 07:56

4

you could use the REPLACE function, so something like:

UPDATE myDatabase.users
SET address = REPLACE( address, '"', '' )
WHERE address LIKE '"%';

answered Sep 23 '13 at 07:56

Rowland Shaw

37,700
14
97
166

How to remove double quote character in MySQL

1 Answers1