MySQL, replacing with… nothing (delete those, please!)

MySQLreplaceWordpress

I'm trying to purge my WordPress content from "false" carriage return (CR). These are caused after a migration of my content, that now presents from time to time a   code that makes the web rendering engine to "paint" a CR where I would like to be nothing. The paragraphs seem to have a double CR because of this, and look too far apart.

I'd like to be able to make a MySQL query in order to get rid of that strings, but at the moment I haven't found the key. What I've tried is

UPDATE wp_posts set post_content = replace (post_content,'&nbsp;',' ');

But i get

<p> </p>

where before were the   strings. This seems not the answer at all. Could it have to be with the ampersand, and in that case, should I use something like &nbsp; or something similar?

Best Answer

I am not sure why   would be interpreted as a carriage return, because it should look like a space (Non-Breaking SPace). In any case, I was able to get your SQL to work on a test database I created by changing the string to have double-quotes.

UPDATE wp_posts set post_content = replace (post_content," ","");

Also note, there is no space between the last pair. You want it to replace   with nothing, not a space.

Related Solutions

WordPress – Syncing multiple wordpress web servers in a farm

We've used Super Flexible File Synchronizer for stuff like this in the past. It works really well and has a number of options to control syncing.

MySQL/Apache: Replace spaces with underscores only in certain URLs

You can use mysql replace function like:

mysql> UPDATE your_table SET your_field = REPLACE(your_field, ' ', '_') WHERE your_field like '/files/HIDDEN_264_%';

This will replace all spaces with underscores in the file name saved in the field your_field.

In order to replace the spaces in part of your string, you can use substring function:

mysql> UPDATE your_table SET your_field = concat(REPLACE(substring(your_field from 1 for 30), ' ', '_'), substring(your_field from 31) WHERE your_field like '/files/HIDDEN_264_%';

The above example, replaces the spaces only in the first 30 characters in your_field. You can customise it according to the type of data you have. If you can not determine the right length (30 in this example), you can use locate function to search for specific pattern (delimiter).

I can not tell you more as I don't know the format of your data.

Best Answer

Related Solutions

WordPress – Syncing multiple wordpress web servers in a farm

MySQL/Apache: Replace spaces with underscores only in certain URLs

Related Topic