CODEWITHSUNDEEP
mysql
user1993021
user1993021

Reputation: 33

Mysql search and replace when involving "http://"

I'm trying to search and replace in MYSQL but get an error. I'm quessing it's because of the "http://"

Anyone got any suggestions when trying replace this type of thing?

Code entered:

update movies_news set select_page = replace(select_page, ‘http://movie’, ‘http://www.movie’);

But it throws the following error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '://movie’, ‘http://www.movie’)' at line 1

Upvotes: 0

Views: 52

Answers (1)

Patashu
Patashu

Reputation: 21773

Posting so it can be accepted:

update movies_news set select_page = replace(select_page, ‘http://movie’, ‘http://www.movie’);

contains smart quotes, which are not interpreted as normal single quotes, thus the syntax error. It should instead be

update movies_news set select_page = replace(select_page, 'http://movie', 'http://www.movie');

In general, be really careful about copying code to and from 'smart' text editors (Microsoft Word, etc)

Upvotes: 2

Related Questions