Jump to content


Photo

Searcha nd replace Value - Help!


  • Please log in to reply
4 replies to this topic

#1 stevebor1

stevebor1
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 22 January 2006 - 01:47 AM

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

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 22 January 2006 - 03:08 AM

UPDATE yabbse_members SET personalText = 'Something Else'
That will change ALL records
Legend has it that reading the manual never killed anyone.
My site

#3 stevebor1

stevebor1
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 22 January 2006 - 03:32 AM

[!--quoteo(post=338817:date=Jan 21 2006, 07:08 PM:name=AndyB)--][div class=\'quotetop\']QUOTE(AndyB @ Jan 21 2006, 07:08 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
UPDATE yabbse_members SET personalText = 'Something Else'
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?

#4 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 22 January 2006 - 03:56 AM

UPDATE yabbse_members SET personalText = 'Something Else' WHERE personalText = 'I Love Yabb!'

Legend has it that reading the manual never killed anyone.
My site

#5 stevebor1

stevebor1
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 22 January 2006 - 04:07 AM

perfect! Thanks





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users