Using Replace in SQL

I have a table and I need to update some names but I was wondering about the

following queries :

Will both do the same?

Query1

Update mytable
Set Name = Replace(Name,'Jeff','Joe')

Query2

Update mytable
Set Name = 'Joe'
where Name = 'Jeff'

No, they will not do the same thing.

-
The amount of effort required by the SQL engine is completely different. In the first query, the engine must go through every row and perform a string replace operation on the Name column. In the second query, it is searching through the table where the name is "Jeff" and just updating the Name column to be Joe.

-
String replacement is wildcard. So in the first query, the Name "Jeffrey" would become "Joerey".

StackExchange Database Administrators Q#163875, answer score: 26