Owyn Posted October 4, 2003 Share Posted October 4, 2003 I think a general cleanup of the mySql Post Text field is required.The broken links do not just affect the links to messages, they also affect the links to emoticons in old posts.Any reference in the database to "www.scotsnewsletter.com/forums" needs to be changed to "forums.scotsnewsletter.com" Quote Link to comment Share on other sites More sharing options...
Owyn Posted October 4, 2003 Author Share Posted October 4, 2003 This example from the mySql manual shows the basic SQL required. REPLACE(str,from_str,to_str) Returns the string str with all occurrences of the string from_str replaced by the string to_str:mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww'); -> 'WwWwWw.mysql.com' This function is multi-byte safe. Quote Link to comment Share on other sites More sharing options...
Scot Posted October 6, 2003 Share Posted October 6, 2003 Owyn, just to let you know I saw this note of yours, and it makes perfect sense. However, it hasn't proven as easy as that. I am looking into this though.-- Scot Quote Link to comment Share on other sites More sharing options...
Owyn Posted October 6, 2003 Author Share Posted October 6, 2003 Owyn, just to let you know I saw this note of yours, and it makes perfect sense. However, it hasn't proven as easy as that. I am looking into this though.-- ScotTx for the update. The theory looked simple. Sorry the practice is painful. Quote Link to comment 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.