netfrugal Posted November 3, 2006 Share Posted November 3, 2006 In my database I have a ton of emails that I want to change:For example:[email protected] to [email protected][email protected] to [email protected][email protected] to [email protected][email protected] to [email protected]I am sure there is a search and replace for mysql that can replace everything between the '@' sign and the '.com' to 'mydomain'but I can't find it.Any help would be appreciated!thanks! Link to comment https://forums.phpfreaks.com/topic/26096-find-and-replace-in-mysql/ Share on other sites More sharing options...
gluck Posted November 3, 2006 Share Posted November 3, 2006 update the column and use the regexp or substring to change the value Link to comment https://forums.phpfreaks.com/topic/26096-find-and-replace-in-mysql/#findComment-119374 Share on other sites More sharing options...
fenway Posted November 4, 2006 Share Posted November 4, 2006 REGEXP can't be used for anything other than matching, but REPLACE() with some LOCATE()s should work just fine. Link to comment https://forums.phpfreaks.com/topic/26096-find-and-replace-in-mysql/#findComment-119410 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.