Tag: SQL

You never know when you're going to encounter data ravaged by clients, cast aside and mauled, an antelope passed by lions to jackals. But fortunately, data is much easier to repair than a gaping wound. Here's the SQL query I'd use to replace non-breaking spaces with regular spaces. You'll need to replace it with whatever your search term is. The queries target both node_revision__body and node__body tables using SQL REPLACE and LIKE…