How to update multiple rows depending on condition in sql

Question

I have a database in which suppose i have a table named Score in Score there are two fields

Id
Name

now when i see that there are many names starting with - for example

-Karl-KSJ
-Jhon-Kate
-Xyz-Abc

now i want to remove leading - from all rows and update them , and leave all rows where name is not starting with - . How can i achieve that in sql . Please mind it that i have millions of records so performance will play a major role .

Thanks,

Ivan Golović · Accepted Answer · 2012-12-05 11:31:16Z

4

Try it like this, it's simple, it might be fast enough:

BEGIN TRAN

UPDATE  Score 
SET     Name = RIGHT(Name, LEN(Name) - 1)
WHERE   LEFT(Name, 1) = '-'

ROLLBACK

Here is an SQL Fiddle

edited Dec 5, 2012 at 11:31

answered Dec 5, 2012 at 11:13

Ivan Golović

8,8223 gold badges27 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

How to update multiple rows depending on condition in sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related