Modifying all data in a given column (SQL)

aftershxck · 3 Sep 2007 at 18:52

Hey,

I've tried googling for a solution to this but I'm not completely sure of what approach I should be taking.

If I had a table with say 100 records, and for a given column, I wanted to modify the data for every row (i.e. append some chars), how would I go about doing this? What is the most efficient way?

Thanks for any advice!

JIMA · 3 Sep 2007 at 19:18

Hi,

You could do an update, something like:

UPDATE mytable
SET mycol = mycol + "Added Text";

That should (I think) update all the rows, adding the text "Added Text" to the mycol column for every row.

Jim

aftershxck · 3 Sep 2007 at 19:24

Hi,

I'll give it a try

Thanks

BruBoy · 3 Sep 2007 at 20:22

concatenation

In mySQL? Take a look at http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat.

In Oracle you can use || to concatenat eg: 'ba' || 'lls'

Moredhel · 3 Sep 2007 at 21:06

I'm not sure if just adding it will work, the CONCAT function will do it though.

UPDATE table SET field = CONCAT(field, 'foo');

TrUz · 3 Sep 2007 at 22:31

if it is MS SQL you can do this:

Code:

UPDATE Table1 SET Column1 = Column1 + 'Text to append';

TrUz