hbalagh Posted October 10, 2010 Share Posted October 10, 2010 I need to run a find and replace UPDATE post SET pagetext = replace(pagetext, "/Deep Water Culture", "deep-water-culture"); is this ok and it will only replace /Deep Water Culture with deep-water-culture or do i have to worry about it finding other references without the / in it and replacing it with deep-water-culture?? Quote Link to comment https://forums.phpfreaks.com/topic/215577-sql-find-and-replace/ Share on other sites More sharing options...
hbalagh Posted October 11, 2010 Author Share Posted October 11, 2010 anyone? Quote Link to comment https://forums.phpfreaks.com/topic/215577-sql-find-and-replace/#findComment-1120983 Share on other sites More sharing options...
hbalagh Posted October 11, 2010 Author Share Posted October 11, 2010 does anyone know if it will work Quote Link to comment https://forums.phpfreaks.com/topic/215577-sql-find-and-replace/#findComment-1121264 Share on other sites More sharing options...
fenway Posted October 17, 2010 Share Posted October 17, 2010 Of course you need to worry -- and there's no where clause. Quote Link to comment https://forums.phpfreaks.com/topic/215577-sql-find-and-replace/#findComment-1122971 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.