wwfc_barmy_army Posted November 11, 2006 Share Posted November 11, 2006 Hello.I have a table in a database (called 'link') and i need to replace the two following things in each of the links in the table:'%3D' with '=''%3F' with '?'I know this is a Mysql replace query but i'm not sure how i would use to with do what i want to do.Any suggestions or code is welcomed Thanks :) Link to comment https://forums.phpfreaks.com/topic/26915-mysql-replace/ Share on other sites More sharing options...
AndyB Posted November 11, 2006 Share Posted November 11, 2006 UPDATE tablename SET something = '=' WHERE something = '%3D' Link to comment https://forums.phpfreaks.com/topic/26915-mysql-replace/#findComment-123148 Share on other sites More sharing options...
fenway Posted November 12, 2006 Share Posted November 12, 2006 And with "nested" replaces you can just issue a single UPDATE statement. Link to comment https://forums.phpfreaks.com/topic/26915-mysql-replace/#findComment-123406 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.