Changing every character in a table
I want to go through a whole table (or tables actually) and replace every
instance of '\n\n' to '\n'
Basically a person entering data has, in some (but not all cases) added
several line breaks rather than a single line break - so text is sometimes
spaced out across the page.
I haven't decided to replace all '\n\n' with '\n' or all '\n\n\n' with
'\n\n' ... but in either case this needs to be done.
Can you think of a MySQL query (or use PHP if needed) that will do this?
All help appreciated
Cheers
|
