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? Quote Link to comment 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.', '') Quote Link to comment 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! 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.