The Little Guy Posted February 12, 2011 Share Posted February 12, 2011 I have a database, and in it are urls. I want to reformat all the urls, how can I do that? right now they look like this: http://site.com/somepage.php or like this: http://www.site.com/somepage.php I want to remove the http:// so it looks like this: site.com/somepage.php I was hoping there was a regexp_replace or something but their is not. What would be the best way to do this? Link to comment https://forums.phpfreaks.com/topic/227472-regexp-replace/ Share on other sites More sharing options...
Pikachu2000 Posted February 12, 2011 Share Posted February 12, 2011 UPDATE `table` SET `field` = REPLACE(LCASE(`field`), 'http://', ''), `field` = REPLACE(LCASE(`field`), 'www.', '') Link to comment https://forums.phpfreaks.com/topic/227472-regexp-replace/#findComment-1173326 Share on other sites More sharing options...
The Little Guy Posted February 13, 2011 Author Share Posted February 13, 2011 Thanks! it looks like that did the trick! Link to comment https://forums.phpfreaks.com/topic/227472-regexp-replace/#findComment-1173425 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.