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. Quote 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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/85020-solved-database-wide-replace/#findComment-436371 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.