Looking for a program like notepad to edit database

Hello,

I have got a very large database. I replace some words. I use notepad. it works ok. but if the word i want to replace is too many, notepad freezes and does not work.

is there any other program that i can use?

thanks

 

UltraEdit is very good (shareware with trail period).
Also try Wordpad.

 

textpad is great for that, just press F5 and replace all words

 

Jarte is a cool new thing..check it out on
www[dot]jarte[dot]com

 

Easiest (free) solution, use phpmyadmin to run replacement queries like

UPDATE table_name SET `field_name`=replace(`field_name`,"original_text",'replacement_text');

Code (markup):

 

huh? Id never think theres someone editing a large db in notepad....I usually write a script like Clive suggesting.

 

Ok. I managed. I used Notepad++
I replaced 1.616.938 words at once without crashing.

 

you do like to risk, dont you

congrats