MySQL Replace Troubles

[apauto]

Hi guys,

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

[coopster]

Your backslash is likely being read as an escape character. Therefore you are escaping the quotation mark.