Find and replace particular string in a column

Question

I have a table in the database where it contains some of the user name. When I copy the database files from one machine to other machine, I need to manually update this table. The table contains the username in the following format

<domain name>\Username

the domain mostly the local machine name (the user exists within the system). What I am trying to write a simple SQL Query to find a pattern (machine name) and replace with a new one.

I am not so proficient with SQL queries. Can you share a sample snippet? I am using SQL Server 2008

did you miss something in the format (in the question) ? What is domain in this context? — abhinav
– abhinav, Commented Nov 9, 2011 at 11:26

dani herrera · Accepted Answer · 2011-11-09 11:28:02Z

9

UPDATE table_that_contains_users
SET field_user = replace( field_user, 'OLDDOMAIN\', 'NEWDOMAIN\')

is that?

answered Nov 9, 2011 at 11:28

dani herrera

52k11 gold badges133 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sinsedrix · Accepted Answer · 2017-03-02 08:45:24Z

0

Try this statement:

UPDATE your_table SET machine_name = REPLACE(machine_name, machine_name, 'Your New Value')

edited Mar 2, 2017 at 8:45

sinsedrix

4,8055 gold badges38 silver badges66 bronze badges

answered Mar 2, 2017 at 8:15

Toshim Shaikh

11 bronze badge

Collectives™ on Stack Overflow

Find and replace particular string in a column

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related