How to replace multiple line breaks

[sifuhall]

I'm trying to replace multiple line breaks in a field with a double line break, but only when there are 3 or more in a row.

So for example I would want to replace \n\n\n with \n\n
and \n\n\n\n with \n\n etc.

I'm trying this but it doesn't seem to work

UPDATE xf_post SET message = REPLACE(message, '\n\n\n', '\n\n')

[PhilipToop]

Are you sure you just have \n as a new line not \r\n?