Mysql Search & Replace

I want to do a search & replace in phpmyadmin.

I want to search for:

http://www.mydomain.com/~%.html

and replace it with:

http://www.mydomain.com/new-link

From what I understand, the % is a wildcard. I’m not sure if the ~ will cause any problems.

How can I do this?

Leave a Reply

Your email address will not be published. Required fields are marked *