ToonMariner Posted January 8, 2008 Share Posted January 8, 2008 Hi, I need a little help - I need to replace every occurance of & p o u n d ; in a database with the £ sign. Is there a query I can run to do this or must I use a REPLACE and do each table and field individually? Many thinks in advance. Link to comment https://forums.phpfreaks.com/topic/85020-solved-database-wide-replace/ Share on other sites More sharing options...
trq Posted January 8, 2008 Share Posted January 8, 2008 I don't think there is anything within sql itself, but you could quite easily write a script to do it within php. Take a look at the mysql_list_tables() and mysql_list_fileds() functions. Link to comment https://forums.phpfreaks.com/topic/85020-solved-database-wide-replace/#findComment-433578 Share on other sites More sharing options...
ToonMariner Posted January 11, 2008 Author Share Posted January 11, 2008 cheers thorpey! I couldn't find a db wide soluntion other than what you suggested - thanks. Link to comment https://forums.phpfreaks.com/topic/85020-solved-database-wide-replace/#findComment-436371 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.