Hello
I hope you guys will understand what i mean ,

i have a database and in this table i have a column named "source"

now, i have lots of data there in the shape of text, names of the sources.

now i have a specific source name i want to change(and there are lots of them)
lets say i want to change it from "X" to "Y"

is there any way to changed it automatically ? not one by one

thanks alot

Danny

update mytable set mycolumn="blah-di-blah" where mycolumn="oujamaflip"

yeap...

just did it more specific

UPDATE table SET author_name='Aju Menu' WHERE author_name='Natal Menu';


Thanks again