blakekr Posted June 26, 2009 Share Posted June 26, 2009 I'm trying to do a simple(?) task of replacing multiple <br>s in my database with newlines (\n\n). This doesn't involve php at all, it's an existing blog database that needs to be cleaned up. Can this be done within mysql? The best I've been able to do so far is *literally* replace the <brs> with \n\n in the text, instead of linebreaks -- no good of course. Any tips? I looked into chr(10) and chr(13) but didn't have luck, wasn't sure that was the right approach anyway. This is mysql 5.0.67. Quote Link to comment https://forums.phpfreaks.com/topic/163726-replacing-with-newlines-in-mysql/ Share on other sites More sharing options...
chmpdog Posted June 26, 2009 Share Posted June 26, 2009 you could do a foreach loop, then do a str_replace () which would work Quote Link to comment https://forums.phpfreaks.com/topic/163726-replacing-with-newlines-in-mysql/#findComment-863898 Share on other sites More sharing options...
Ken2k7 Posted June 26, 2009 Share Posted June 26, 2009 UPDATE table SET column = REPLACE(column, "<br>", "\n\n"); Quote Link to comment https://forums.phpfreaks.com/topic/163726-replacing-with-newlines-in-mysql/#findComment-863904 Share on other sites More sharing options...
chmpdog Posted June 26, 2009 Share Posted June 26, 2009 it appears I have just been schooled. Quote Link to comment https://forums.phpfreaks.com/topic/163726-replacing-with-newlines-in-mysql/#findComment-863920 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.