stevebor1 Posted January 22, 2006 Share Posted January 22, 2006 what querey do i run in myphpadmin to search and replace. i have a table (yabbse_members) with a field called (personalText). I want to replace the initial value "I Love YaBB!" to something else. What do i need to type to search and replace? i have about 250 members that i need to change. Thanks Quote Link to comment Share on other sites More sharing options...
AndyB Posted January 22, 2006 Share Posted January 22, 2006 [code]UPDATE yabbse_members SET personalText = 'Something Else' [/code]That will change ALL records Quote Link to comment Share on other sites More sharing options...
stevebor1 Posted January 22, 2006 Author Share Posted January 22, 2006 [!--quoteo(post=338817:date=Jan 21 2006, 07:08 PM:name=AndyB)--][div class=\'quotetop\']QUOTE(AndyB @ Jan 21 2006, 07:08 PM) [snapback]338817[/snapback][/div][div class=\'quotemain\'][!--quotec--][code]UPDATE yabbse_members SET personalText = 'Something Else' [/code]That will change ALL records[/quote]ok, but i want to change only those that have "I Love Yabb!" and not the others. do i do a SEARCH of some kind? Quote Link to comment Share on other sites More sharing options...
AndyB Posted January 22, 2006 Share Posted January 22, 2006 [code]UPDATE yabbse_members SET personalText = 'Something Else' WHERE personalText = 'I Love Yabb!' [/code] Quote Link to comment Share on other sites More sharing options...
stevebor1 Posted January 22, 2006 Author Share Posted January 22, 2006 perfect! Thanks 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.