Replace in MySQL

[M Meyer]

I am trying to do an update/replace function in MySQL but I am getting MySQl error #1064. Basically the query is just trying to update a field called Description in a table called Widgets by changing some values to a new value. So, for example, I want to change the field 'oldvalue123' to 'newvalue123'

The query works well in MS SQL 2000 but not in MySQL- Here is the query

Update Widgets
Set Description = (Select Replace(Description,'oldvalue','newvalue'))
From Widgets

Any idea of how to get this to work in MySQL?