I'm trying to do a few nested replace's in a select statement in MySQL, and it keeps throwing an error.

Do you see a problem?

select * from OEM where replace(replace(replace(replace(replace(replace(replace(productname, ' ', ''), '-', ''), '/', ''), '\', ''), '&', ''), 'amp;', ''), '.', '') = 'widget'

Thanks