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
Code:UPDATE xf_post SET message = REPLACE(message, '\n\n\n', '\n\n')