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. 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 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"); 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. 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
Archived
This topic is now archived and is closed to further replies.