CODEWITHSUNDEEP
phpmyadmin
Robert
Robert

Reputation: 812

Update all rows in the PhpMyAdmin

I want to change in the PhpMyAdmin the text "pelecard" for all fields that contain this text. the table name is sales_flat_order_payment. How I can do this?

enter image description here thank you

Upvotes: 4

Views: 4141

Answers (2)

Marc Delisle
Marc Delisle

Reputation: 8997

Can also be done directly in phpMyAdmin. Open the table, choose "Search" then "Find and replace".

Upvotes: 1

René Höhle
René Höhle

Reputation: 27305

What is with SQL? 

UPDATE sales_flat_order_payment SET method="123"

Then you change all fields to a new value. Without a where clause you change all entries.

Upvotes: 9

Related Questions