February 22, 2012 at 4:24 am
HI All,
I want to update the data in a particular column[column data type is String ] .
Ex: The data in the column is 'www.sql.com' , Now i want to change like this
'qa.sql.com' . The coulmn contains almost 500 records of data. I want to change all the records of that particular column .
Please help on this is issue. Its very urgent .
Thanks,
Lavanya
February 22, 2012 at 4:26 am
February 22, 2012 at 5:01 am
Thanks ,
I got the solution for my problem .
UPDATE tablename
SET columnname = replace(columnname,'olddata', 'newdata')
WHERE columnname LIKE 'abc%';
Thanks
Lavanya
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply