Link to home
Start Free TrialLog in
Avatar of willsherwood
willsherwood

asked on

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
Avatar of Cornelia Yoder
Cornelia Yoder
Flag of United States of America image

htmlentities()
Avatar of willsherwood
willsherwood

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.
ASKER CERTIFIED SOLUTION
Avatar of Cornelia Yoder
Cornelia Yoder
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
select replace(myfield, '%20', ' ');
thanks