Mysql replace question

Databases
1

OK - bit of a weird one here - I’m looking to replace a character in my database with a " - this is what I have, and it doesn’t like it :frowning:

UPDATE store_products SET description = replace(description,"ø",""")

I’ve tried wrapping it in other quotes - but that doesn’t work… how do I do it?

2

Ah - replace both sets of quotes… makes sense really.

Thanks r937 :slight_smile:

3 
UPDATE store_products 
   SET description = REPLACE(description,[B][COLOR="Red"]'[/COLOR][/B]ø[B][COLOR="Red"]'[/COLOR][/B],[B][COLOR="Red"]'[/COLOR][/B]"[B][COLOR="Red"]'[/COLOR][/B])