I have a small db, that has news.
I want to update the field "content" to add the phraze "<br>Aproved by Admin" for every row in the database.
A better explanation, i have table news, with 1 table that is defined : create table news (id int, creator char(10), content char(255));
and for example i have 2 rows:
insert into news values (1,"admin","test1"); insert into news values (1,"nonadmin","test2");
i want to update all the values of the content be current content+"<br>Aproved by Admin"
How can i do that ?
Thanks in advance.