text error in mysql

L

louise

Guest
I've been updating a database and I wish to change a string of text to read something different. I don't want to go through all the records again and edit them individually. Does anyone know an easier way to do this either using mysql (phpadmin) or dadabik??
Thanks for your help.

 
D

Debbie S

Guest
Louise

On occasion, I've had to edit bulk data in a database table. What I found easiest was to export the database from phpMyAdmin, make my changes using Search/Replace in Notepad and then import the sql file back into the database. Of course, before importing the data back, you have to empty the database otherwise you'll get errors that tables exist.

Hope that helps!

Debbie
(Latest version of DaDaBIK when this message was posted: 3.1 Beta)
 
Top