denoteone Posted July 28, 2010 Share Posted July 28, 2010 below is the mysql query I am trying to run to update all the URL's in my database field. update content_type_press set field_press_body_value = replace(field_press_body_value, ‘1%21_cache-caching.php’, ‘caching.php’); this is the error I am getting. #1054 - Unknown column '‘1' in 'field list' Could it have something to do with the "%" because when I inserted the string into the database it was actually 1!_cache-caching.php Link to comment https://forums.phpfreaks.com/topic/209109-update-string-in-database-using-replace/ Share on other sites More sharing options...
awjudd Posted July 28, 2010 Share Posted July 28, 2010 I'm guessing it has to do with your single quotes. They look to be a different character ... but that could just be the font ... ~juddster Link to comment https://forums.phpfreaks.com/topic/209109-update-string-in-database-using-replace/#findComment-1092130 Share on other sites More sharing options...
fenway Posted July 29, 2010 Share Posted July 29, 2010 They look like backticks. Link to comment https://forums.phpfreaks.com/topic/209109-update-string-in-database-using-replace/#findComment-1092565 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.