MySQL Query to go through entries in a field and remove whitespace

[Gazthrak]

I am working on an import from an old system into a new one and unfortunately, I have to remove spaces in product codes because the new system freaks out when it is read a product code with a space in it. I know how to get preceding and trailing whitespace but not whitespace in the middle. Can anyone help?

Thank you.

[dingbat]

Use the REPLACE function.