Update part of table

[Bengyke]

I have an SQL database "aaa" with table "bbb". In this table I have a field named "emailaddr". In this field, at the moment there is a value test@hostname.com

Who can I change only the hostname.com value in the field ?

So I am searching for an UPDATE command where I can define this part of the field.

 

[r937]

depending on which database system you're using...

update bbb
set emailaddr
= replace(emailaddr,'hostname.com','example.com')

r937.com | rudy.ca

 

[r937]

forget to add the WHERE clause to prevent updating all rows needlessly...

update bbb
set emailaddr
= replace(emailaddr,'hostname.com','example.com')
where emailaddr like '%hostname.com'

r937.com | rudy.ca