About
Pricing
Community
Teams
Start Free Trial
Log in
willsherwood
asked on
2/15/2010
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
6
1
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