MySQL STRING REPLACE how to escape % character for a literal percent character

i want to replace exactly the literal string "%20" with space (" ")

how can i escape % so it's not a wildcard character?

thanks

MySQL Server

Last Comment

willsherwood

8/22/2022 - Mon

Cornelia Yoder

2/15/2010

htmlentities()

Cornelia Yoder

2/15/2010

http://us.php.net/manual/en/function.htmlentities.php

willsherwood

2/15/2010

ASKER

i want to do a MySQL query with REPLACE to fix the data in fields.

how does it know about the PHP htmlentities() function? i think i'm missing something, sorry.

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

rwheeler23

ASKER CERTIFIED SOLUTION

Cornelia Yoder

2/15/2010

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

ViaTom

2/15/2010

select replace(myfield, '%20', ' ');

willsherwood

2/15/2010

ASKER

thanks

Certified Expert Program

Credly Partnership

Udemy Partnership