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 Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.